Upper/Lower case query

[thendal]

Hi all!

Could some help me ..how i can fetch datas like


"Thendal" and "thenDal" ie) i need a query which will fetch data irrespective of the case..

any help will be more appriciated

Thanks

 

[tlbroadbent]

You could use the UPPER (UCASE) or LOWER (LCASE) functions.

Select * From Table
Where UPPER(ColumnA)=UPPER('string') Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[thendal]

Thanks terry ,It worked ...

Regards,
Thendal