Skip to Content
0
Former Member
Jan 28, 2010 at 04:43 AM

Selecting text field from table ignoring capitalization

22 Views

Hi,

i'm doing a read on a table using select.....where text in s_text . if i want to ignore the capitalization; how to perform the read.

for eg : if the text is saved as 'Name' and in my select criteria if i specify the selection text as 'name' it should pick up even if 'N' is not in CAPS in DB.

Thanks,

GV.