topic Re: Case sensitive in select queries ?? in Application Development and Automation Discussions

Case sensitive in select queries ??

Former Member — Mon, 22 Sep 2014 08:29:10 GMT

Hi All,

I need to write a query which will search for all case(Upper or lower or Upper+lower) of a string .

I have googled and searched through sdn and found lot of links and documents for case insensitive search and i didn't found final solution..

Please help with helpful suggestions .

Regards,

Lokeswar Reddy Byni

Re: Case sensitive in select queries ??

Former Member — Mon, 22 Sep 2014 08:34:16 GMT

In most cases SQL is case sensitive. But this really depends on your collation and you DB used in background. However, in most DB systems there is some kind of a lower() function. so you could do something like:


SELECT *
FROM my_table
WHERE lower(my_tyble.field) = 'myString';

(This is really pseudo code. You should check for you scenario before ... )

On some DB with some collation you don't need to do this, as it's per default non-case sensitive. HTH

Re: Case sensitive in select queries ??

rosenberg_eitan — Mon, 22 Sep 2014 08:41:20 GMT

Hi,

Native SQL to the rescue.

See

and program ADBC_QUERY .

Regards.

Re: Case sensitive in select queries ??

Former Member — Mon, 06 Oct 2014 07:16:55 GMT

This message was moderated.