problem is select statement !

[naveenvishal]

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%'.

[former_member404244]

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

[naveenvishal]

no ..not all records ..records containg abc with the described pattern..like abc ABC Abc aBC..

[Former Member]

Hi Naveen,

You can use OR condition in SELECT statement.

Like select ... from ... where X like 'abc' or X like 'Abc'.

[former_member404244]

hI,

Try like this

select......where x like 'Abc%' OR 'ABc%'...like this..

Regards,

Nagaraj