Query regarding select

[Former Member]

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.

[Former Member]

u have where a LIKE C.

operator LIKE to compare in where clause chck that..

reward if it helps uu..

[Former Member]

Select a b from yplaylist into table i_playlist where

a eq c.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

Try this

Select a

b

from ypaylist

into table i_paylist

where a = c.

if sy-subrc eq 0.

endif.