Hi, i'm trying to test some stuff on odbc, but i cant seem to do regular expressions..
ie stuff like SELECT * FROM TABLE WHERE USERNAME LIKE '%[0-9]%'
doesnt seem to work ..
any ideas?

Zman wrote:
> Hi, i'm trying to test some stuff on odbc, but i cant seem to do
> regular expressions.. ie stuff like SELECT * FROM TABLE WHERE
> USERNAME LIKE '%[0-9]%'
> doesnt seem to work ..

Why should it work?

Ralf

"Ralf Mimoun" <nospam@rad-on.de> wrote:

Zman wrote:
> Hi, i'm trying to test some stuff on odbc, but i cant seem to do
> regular expressions.. ie stuff like SELECT * FROM TABLE WHERE
> USERNAME LIKE '%[0-9]%'
> doesnt seem to work ..

Why should it work?

Ralf

?? what do u mean..  why shouldn't it work?
how else would you do regular expressions?

Zin

Zman <pikachu@centra.ca> wrote on Tue, 18 Jul 2006 15:09:09 -0400

>"Ralf Mimoun" <nospam@rad-on.de> wrote:
>
>Zman wrote:
>> Hi, i'm trying to test some stuff on odbc, but i cant seem to do
>> regular expressions.. ie stuff like SELECT * FROM TABLE WHERE
>> USERNAME LIKE '%[0-9]%'
>> doesnt seem to work ..
>
>Why should it work?
>
>Ralf
>
>?? what do u mean.. why shouldn't it work?
>how else would you do regular expressions?
>
>Zin
>
Zman



I think Ralf meant that you shouldn't expect LIKE to handle regular expressions.

v3 helps says:-

[NOT] LIKE    Extended operator for wildcard field value comparisons using the % (multiple) or _ (single) wildcard characters


Jeff Cook



--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz

Jeff Cook <jeffc@aspect.co.nz> wrote:

Zman <pikachu@centra.ca> wrote on Tue, 18 Jul 2006 15:09:09 -0400

>"Ralf Mimoun" <nospam@rad-on.de> wrote:
>
>Zman wrote:
>> Hi, i'm trying to test some stuff on odbc, but i cant seem to do
>> regular expressions.. ie stuff like SELECT * FROM TABLE WHERE
>> USERNAME LIKE '%[0-9]%'
>> doesnt seem to work ..
>
>Why should it work?
>
>Ralf
>
>?? what do u mean.. why shouldn't it work?
>how else would you do regular expressions?
>
>Zin
>
Zman



I think Ralf meant that you shouldn't expect LIKE to handle regular expressions.

v3 helps says:-

[NOT] LIKE    Extended operator for wildcard field value comparisons using the %
(multiple) or _ (single) wildcard characters


Jeff Cook



--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz

Jeff, thanks for the reply.
so i guess LIKE doesnt support reg expressions in v3?
does anything support regular expressions in dbisam?
thanks.
Zman

Zman,

<< Hi, i'm trying to test some stuff on odbc, but i cant seem to do regular
expressions.. ie stuff like SELECT * FROM TABLE WHERE USERNAME LIKE
'%[0-9]%'doesnt seem to work ..  >>

DBISAM doesn't support using regular expressions in SQL statements.
However, with version 4.x you can define a custom SQL function that can do
it.   You can find more information on creating custom SQL functions here:

http://www.elevatesoft.com/dbisam4d5_customizing_engine.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Zman wrote:
....
> Why should it work?
>
> Ralf
>
> ?? what do u mean..  why shouldn't it work?

What makes you expect that DBISAM (or any other SQL dialect) supports
regular expressions? IOW: why should such a statement work / be valid?

Ralf

"Ralf Mimoun" <nospam@rad-on.de> wrote:

Zman wrote:
....
> Why should it work?
>
> Ralf
>
> ?? what do u mean..  why shouldn't it work?

What makes you expect that DBISAM (or any other SQL dialect) supports
regular expressions? IOW: why should such a statement work / be valid?

Ralf


OH, i only thought.. because.. Maybe because it works in mysql, oracle, ms sql 2005, IBM DB.
so i just figured why shouldn't it work Ralf.. and yes i confirm it does work on those
above. because i've tested it.


Tim : thanks for the reply

Zman