topic Re: String manipulation in Application Development and Automation Discussions

String manipulation

Former Member — Fri, 24 Apr 2009 13:42:24 GMT

Hi,

i have to pass to select statement for bukrs field as tw**, Why means the company code may be tw01 or tw02....twnn. can anybody advise me how can do this.

Moderator message - Please look at the help for SELECT before asking basic questions like this - Post locked

Edited by: Rob Burbank on Apr 24, 2009 10:00 AM

Re: String manipulation

Former Member — Fri, 24 Apr 2009 13:45:14 GMT

Hi,


Pass it as' TW%'  to select query it will work..

Select bukrs from table where bukrs = 'TW%'.    "Try withEQ or LIke i am not sure but one will work

Select bukrs from table where bukrs like 'TW%'.

it iwll fetch all tw01,tw01 it will acts as a TW*

regards,

Prabhudas

Re: String manipulation

Former Member — Fri, 24 Apr 2009 13:48:28 GMT


SELECT abc
  FROM  xyz
WHERE bukrs LIKE 'tw%'.