Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

problem is select statement !

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

Tags:
Former Member replied

hI,

Try like this

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

Regards,

Nagaraj

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question