topic Re: Using LIKE in Select query in Application Development and Automation Discussions

Using LIKE in Select query

Former Member — Thu, 16 Oct 2008 12:03:58 GMT

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

Re: Using LIKE in Select query

Former Member — Thu, 16 Oct 2008 12:11:52 GMT

Hello,

Better you select Lowecase option is the domain of the DESCRIPTION field then u can fetch the data from Ztable.

Re: Using LIKE in Select query

former_member156446 — Thu, 16 Oct 2008 12:12:33 GMT

using translate to upper case should help.

or you can populate a range table/ select options kind of table and so_vlaue-low = te% so_vlaue-high = TE%

Re: Using LIKE in Select query

ThomasZloch — Thu, 16 Oct 2008 12:14:14 GMT

This can be done by adding another field to ZTABLE that duplicates the contents of DESCRIPTION in upper case (or lower case). Then your select could use this new field to search for the pattern, after converting it to upper case (or lower case).

Thomas

Re: Using LIKE in Select query

Former Member — Thu, 16 Oct 2008 12:56:32 GMT

Hi jay,

e_sel-sign = 'I'.

e_sel-option = 'BT'.

e_sel-low = 'te%'.

e_sel-high = 'TE%'.

APPEND e_sel TO i_sel .

SELECT *

FROM ztable

INTO CORRESPONDING FIELDS OF TABLE t_list

WHERE description IN i_sel.

This does not work ..:(...

how

Re: Using LIKE in Select query

former_member156446 — Thu, 16 Oct 2008 13:02:20 GMT

e_sel-sign = 'I'.

e_sel-option = 'BT'.

e_sel-low = 'te%'.

e_sel-high = 'TE%'.

APPEND e_sel TO i_sel .clear e_sel.

e_sel-sign = 'I'.

e_sel-option = 'BT'.

e_sel-low = 'tE%'.

e_sel-high = 'Te%'.

APPEND e_sel TO i_sel .clear e_sel.

SELECT *

FROM ztable

INTO CORRESPONDING FIELDS OF TABLE t_list

WHERE description IN i_sel.

SELECT *

FROM ztable

INTO CORRESPONDING FIELDS OF TABLE t_list

WHERE description+0(2) in ( 'te%', 'TE%' , 'Te%', 'tE%').

Re: Using LIKE in Select query

Former Member — Thu, 16 Oct 2008 13:09:53 GMT

Thanks Jay

But the serach can be any thing like Test* or traIN* ...

What will i do...?

Re: Using LIKE in Select query

christine_evans — Thu, 16 Oct 2008 14:05:41 GMT


> Thanks Jay
> 
> But the serach can be any thing like Test* or traIN* ...
> 
> What will i do...?

Following the suggestion of Thomas Zloch above would seem to me to be the best solution. It's what SAP does in this situation eg in table LFA1 where (in our system at least) MCOD1 holds an uppercase version of NAME1.

Re: Using LIKE in Select query

Former Member — Thu, 16 Oct 2008 14:10:51 GMT

This can really only be done using native SQL (that is, if your database supports something like 'translate').

Rob