Skip to Content
0
Nov 14, 2007 at 05:31 AM

problem is select statement !

12 Views

i want to trap following strings from the field:

Field Name : x (suppose)

ABC

Abc

abc

aBC

how to write the select code to reterieve all the records above.

i.e., case sensitivity is ignored.

currently im writing: select......where x like 'Abc%'.