Case sensitive in select queries ??

[Former Member]

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

[Former Member]

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

[Former Member]

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

[rosenberg_eitan]

Hi,

Native SQL to the rescue.

See

and program ADBC_QUERY .

Regards.

[Former Member]

This message was moderated.