topic Re: problem is select statement ! in Application Development and Automation Discussions

problem is select statement !

naveenvishal — Wed, 14 Nov 2007 05:31:20 GMT

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 — Wed, 14 Nov 2007 05:36:51 GMT

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 — Wed, 14 Nov 2007 05:40:38 GMT

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

Former Member — Wed, 14 Nov 2007 05:42:22 GMT

Hi Naveen,

You can use OR condition in SELECT statement.

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

former_member404244 — Wed, 14 Nov 2007 05:54:07 GMT

hI,

Try like this

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

Regards,

Nagaraj