String manipulation

[Former Member]

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

[Former Member]

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

[Former Member]

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