topic Re: Query regarding select in Application Development and Automation Discussions

Query regarding select

Former Member — Fri, 02 Mar 2007 08:29:54 GMT

How do i do string comparisons in the where clause of a select.

Something like:

data: c(20).

c = 'Music'.

Select a b from yplaylist into table i_playlist where

a CO c.

Re: Query regarding select

Former Member — Fri, 02 Mar 2007 08:31:16 GMT

u have where a LIKE C.

operator LIKE to compare in where clause chck that..

reward if it helps uu..

Re: Query regarding select

Former Member — Fri, 02 Mar 2007 08:31:37 GMT

Select a b from yplaylist into table i_playlist where

a eq c.

Re: Query regarding select

Former Member — Fri, 02 Mar 2007 08:33:17 GMT

HI Asha,

If you want the exact string to be matched, then you can directly uuse

Select a b from yplaylist into table i_playlist where

a = c.

If you want a matchin the patterns, i.e. all the strings that contain a string 'Music', then use like syntax.

Select a b from yplaylist into table i_playlist where

a like '%Music%'.

Re: Query regarding select

Former Member — Fri, 02 Mar 2007 08:35:11 GMT

Hi,

Try this

Select a

from ypaylist

into table i_paylist

where a = c.

if sy-subrc eq 0.

endif.

Re: Query regarding select

Former Member — Fri, 02 Mar 2007 08:42:47 GMT

Hi Ravi,

I want to get the various values from table which is exactly or contains music. So instead of hardcoding , can i just use

Select a b from yplaylist into table i_playlist where a like c.

Re: Query regarding select

Former Member — Fri, 02 Mar 2007 08:46:14 GMT

if u dont want to hardcode then declare the variable and use in select statement.

date: g_cat(7) type c value '%Music%'.

Re: Query regarding select

Former Member — Fri, 02 Mar 2007 08:49:02 GMT

No the value keeps changing. So i capture it in a variable and do the comparison. So it has to be dynamic.

Re: Query regarding select

Former Member — Fri, 02 Mar 2007 09:30:16 GMT

To Do that you ave to concatenate '%' in front and after the actual word.

Assume that the word you want to check is in a variable v_word.

then do like this:

concatenate '%' v_word '%' into c.

Select a b from yplaylist into table i_playlist where a like c.

Regards,

Ravi