Select query

Hi,

S114010001

S118000001

S840100001

S168000001

S840100001

S128000001

S840100001

S128000001

I want to write a select queries where I need to pick the entries starting with S11* or S12*.

Similar way another query where it picks entries that will not start with S11* or S12*.

Example:

select single hkont into x_hkont from bseg where

belnr = vbrk-vbeln

and hkont like 'S11%'

or hkont like 'S12%'.

will the above query works? also I need other query where hkont is not equal to S11% or S12% that means it should select other than S11* or S12*.

Best Regards

MS