Thread: Regd Query
View Single Post
  #1 (permalink)  
Old 04-07-2008, 09:55 AM
princy princy is offline
Junior Member
 
Join Date: Mar 2008
Posts: 1
princy is on a distinguished road
Default ANY dialect question:

Regd Query


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
Reply With Quote

ANSWER(S):