Skip to Content

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

Using LIKE in Select query

Hi experts,

I am writing a Function module to get data from a table.

Import :

desc TYPE ZTABLE-DESCRIPTION.

-


Now when desc = te*

REPLACE ALL OCCURRENCES OF '*' IN

desc WITH '%' .

SELECT *

FROM ZTABLE

INTO CORRESPONDING FIELDS OF TABLE t_list WHERE DESCRIPTION LIKE desc.

-


.. With is the table fetches all records where description starts with " te " .. here te is case senstive

So if description is "Test " or " TEST " or "tE" ......... so on.. i want this like to be made case in sensitive

Coz user can search as per his/her way...

Regards,

Bijal

Tags:
Not what you were looking for? View more on this topic or Ask a question