2007 Nov 14 5:31 AM
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%'.
2007 Nov 14 5:54 AM
hI,
Try like this
select......where x like 'Abc%' OR 'ABc%'...like this..
Regards,
Nagaraj
2007 Nov 14 5:36 AM
Hi,
if u want all the records for the field ,then no need to specify the where condition.
do like this
select x from <dbtable> into table itab.
Now u will get all the records...
Regards,
Nagaraj
2007 Nov 14 5:40 AM
no ..not all records ..records containg abc with the described pattern..like abc ABC Abc aBC..
2007 Nov 14 5:42 AM
Hi Naveen,
You can use OR condition in SELECT statement.
Like select ... from ... where X like 'abc' or X like 'Abc'.
2007 Nov 14 5:54 AM
hI,
Try like this
select......where x like 'Abc%' OR 'ABc%'...like this..
Regards,
Nagaraj