SQL quiestion

[melamoud]

guys,

I know this is a big one and probably the answer is no , no easy way to do that, but I thought I will ask anyway

Is there a way to instruct the 'where clause' to be case insensitive
so if I do select * from table where name ='john'
it will get John and JOHN and john etc ?

I know I can do to upper case in index fields, but then I need to keep the original string in a seperate field and thats just bad solution

thanks

 

[klaus]

Try this:

SELECT * FROM table WHERE lower(name) ='john'

I haven't tested it.

Best regards.

 

[melamoud]

Try this:

SELECT * FROM table WHERE lower(name) ='john'

I haven't tested it.

Best regards.

I just did, cool, its working!


thanks your the man!