My target table is created as NOT CASESPECIFIC by default.
I have uppercase letters and lowercase letters in my table.(eg: In name column :1)ravi 2)MANI 3)HARI 4) suresh)
How can we retrive only lower case letters in the table without specifying CASESPECIFIC in a table?
Thanks in advance...
Try setting to ANSI mode;
.set session transaction=ANSI
You can simply add CASESPECIFIC within your query:
WHERE col (CASESPECIFIC) = 'suresh'
If you always need to get a case sensitive comparison you should better change the column definition to CASESPECIFIC.
Hi Dnoeth and Raja,
Thanks for posting the right answers for my questions.
I tried it is working .By using above i can retrive only upper case or lower case letters in my columns.
Thank's once again.