Help me

[ram007]

Hi this is Surya.
I query is in my table one field is not unique key and it data type is string. In my query I want to SELECT DISTINCT BATCH_NAME FROM BATCH_PHOTOS_TABLE WHERE BPT_BATCH_NAME = '?' but it is case sensitive how to make this query use for both cases (upper and lower cases)
Any build function is there for case sensitive
In my table BATCH_NAME is “ABC”
I am selecting SELECT DISTINCT BATCH_NAME FROM BATCH_PHOTOS_TABLE WHERE BPT_BATCH_NAME =’abc’
My query should return from the data base if it is having ‘ABC’ or ‘abc’ it should not depend on case sensitive.

Thanks & Regards.
Surya

[Rainbow River]

this link will help you:
http://www.databasejournal.com/featu...le.php/3487696