Case Sensitive

In our queries AW will display the result in a grid. All the queries has the filter at the top of the grid.

My issue is:

How can I disable the case sensitive in the filter . Currently user need to enter accurate case for the filter in order for it to properly filter .
How can the queries to disable case sensitive duri appreciated.ng the db queries. I am using oracle

Any suggestion or direction is really

Hi,

I am not 100% sure about Oracle, but you might try setting this on your session in ORACLE not AWAREIM

alter session set NLS_SORT = GENERIC_BASELETTER;

From our app, we don't have such issues in MSSQL, the filter on top of the query returns both upper and lower-case.

I haven't used Oracle for a long time but give that a try. I am sure that it is Oracle you have to set to remove the case sensitivity.

Hope this helps