Skip to Content
0
Feb 27, 2008 at 10:51 PM

Need to run a Select Statement that is not case sensitive

17 Views

I hope somebody can help me find a solution for this. I'm trying to run a Select Statement that ignores the case sensitivity of the value stored in the database.

For example table BUT000 has field NAME_FIRST. One record has NAME_FIRST = 'Gene'.

If I run the statement:

SELECT NAME_FIRST

FROM BUT000

WHERE NAME_FIRST = 'gene'.

This statement will return 0 result.

Same thing happens when I change to 'GENE'.

Is there a way to turn off the case sensitivity of SQL statements? Thanks for the help!