Hi,

I have in table Person, having column Name, where data is like,

JOHN
john


When I am executing the SELECT Query on the name column,

SELECT * FROM PERSON WHERE NAME = 'john';

I am getting result corresponding to small letters john and not JOHN.

How I should create query so that I will get both results.

Thanks all.

Use:

Do not expect it to perform well.

Andy