Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select query case insensitive for data type VARG

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

Former Member
Not what you were looking for? View more on this topic or Ask a question