problem is select statement !
i want to trap following strings from the field:
Field Name : x (suppose)
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%'.
Try like this
select......where x like 'Abc%' OR 'ABc%'...like this..