Skip to Content
0
Apr 17, 2009 at 05:07 AM

Select query case insensitive for data type VARG

36 Views

Hi Experts,

I am having trouble in retrieving the results from a table using select query.

I have a table (Users) as below

Name (VARG) Number(INTEGER)

-


Murthy 0001

murthy 0002

-


when I am querying the table with select query as -


select * from Users where Name = 'Murthy'

this query is returning only one record which matches with capital letter of 'M', though both the record names are same.

I have seen in IBM forum to make the select query as case insensitive using the UPPER key word, I have tried this as below -


select * from Users where UPPER(Name) = 'MURTHY'

But this query is not working in my case...

My DB2 version is 8.1.5

Can any one please help in fixing this problem...

Thanks in Advance,

Murthy