Using LIKE in Select query
I am writing a Function module to get data from a table.
desc TYPE ZTABLE-DESCRIPTION.
Now when desc = te*
REPLACE ALL OCCURRENCES OF '*' IN
desc WITH '%' .
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...