Dear All,

In a file(ITH). There is a field called IPROD.
For this field values are like "ebottle","EBOTTLE","INSULIN","insulin"

Here i need to select the first "ebottle" either it is capital letter or small letter .theni need to select the records "insulin" either capital or small.

Please can any one help me.

Thanks in advance

With regards
Princy

i didn't get what u really wanna ask.....make it clear

but as much as i could understand ,i had provided the result.
plz chk whether its fulfilling what u wanted.



SELECT IPROD FROM ITH
ORDER BY IPROD