Select Statment

[Former Member]

Dear All

I want to use select statement like follows

In the Select statement I want to find field values like not Begin with 'A'

i can use Where <field name> Like 'A%'

in this case all Begin with 'A' values came

but i want not begin with 'A' please help to sole this.

[Former Member]

use where fieldname <b>not like</b> 'A%'.

regards

shiba dutta

[Former Member]

Then use NOT lIKE

this will do it..

Thanks and reward if helpful

[Former Member]

Hi,

Use <fieldname> NP A*.

NP = Not like.

Thanks!

Brunda

'Reward if useful'.

[varma_narayana]

Hi..

Try this way..

SELECT * FROM LFA1 WHERE NAME1 <b>NOT LIKE 'A%'.</b>

Reward if Helpful.

[Former Member]

Hi

use NOT LIKE at that condition

but allways sap advises don't use negative operation on SELECT statment

because it will result in bad performance

reward if usefull

[Former Member]

Hi Nelson,

First select the names with the required key fields without giving any comparison for the name.Later delete the records which starts with "a" from it.

Select filedname from tablename into itab where key1.

if sy-subrc eq 0.

delete from itab where fieldname(1) <> 'a'.

endif.

otherwise u can:

loop at itab into wa where fieldname(1) = 'a'.

append wa to itab1.

endloop.

Thanks,

Kaveri

[Former Member]

Use the statement

SELECT * FROM KNA1 WHERE NAME1 <b>NOT LIKE</b> 'A%'.

[Former Member]

Thanks All

I got the Result

[Former Member]

Great ... then assign points to helpful answers and pls close the thread.

regards

shiba dutta