SQL Query Case Insensitive

[kkarnez]

Hello,
I want a query for a search page, that will be case insensitive for the strings that I pass as parameters. How can it be done?

For example

select * from tasks where name like '%test%'

returns the entries with the keyword "test" but not the ohers with the keyword "Test".

Thanks for your help...

 

[WP]

Your syntax is wrong. Access Like uses * as the wildcard and double quotes.

Thus your query shoul be :

select * from tasks where name like "*test*";



Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch