Case Sensitive...

[mitch77]

Hi,
How can i disable the case sensitive, when executing a select?

Thanks, Mitch

 

[dklloyd]

Hi
You can change your session to the server by using the "SET SQLC MIXED|UPPER|LOWER" if the database is in one or other, MIXED will leave it asis.
Apart from that the UPPER function within DECODE is all I can think of at the moment.

Hope that gets you by..

Dave

 

[carp]

If you don't want the case setting to apply to your entire session, just use the case-changing functions in your select statement:

SELECT col1, col2, ...,coln
FROM my_table
WHERE UPPER(employee_name) = 'SMITH';

One thing I have seen people do that really screws up the works is to forget what their target string should look like:

SELECT col1, col2, ...,coln
FROM my_table
WHERE UPPER(employee_name) = 'Smith'; <=== This will guarantee &quot;No Data Found&quot;!