topic Re: Select Statment in Application Development and Automation Discussions

Select Statment

Former Member — Wed, 17 Oct 2007 05:47:09 GMT

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.

Re: Select Statment

Former Member — Wed, 17 Oct 2007 05:48:51 GMT

use where fieldname not like 'A%'.

regards

shiba dutta

Re: Select Statment

Former Member — Wed, 17 Oct 2007 05:51:25 GMT

Then use NOT lIKE

this will do it..

Thanks and reward if helpful

Re: Select Statment

Former Member — Wed, 17 Oct 2007 05:53:17 GMT

Hi,

Use <fieldname> NP A*.

NP = Not like.

Thanks!

Brunda

'Reward if useful'.

Re: Select Statment

varma_narayana — Wed, 17 Oct 2007 05:54:09 GMT

Hi..

Try this way..

SELECT * FROM LFA1 WHERE NAME1 NOT LIKE 'A%'.

Reward if Helpful.

Re: Select Statment

Former Member — Wed, 17 Oct 2007 05:56:57 GMT

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

Re: Select Statment

Former Member — Wed, 17 Oct 2007 06:01:46 GMT

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

Re: Select Statment

Former Member — Wed, 17 Oct 2007 06:04:57 GMT

Use the statement

SELECT * FROM KNA1 WHERE NAME1 NOT LIKE 'A%'.

Re: Select Statment

Former Member — Wed, 17 Oct 2007 06:11:45 GMT

Thanks All

I got the Result

Re: Select Statment

Former Member — Wed, 17 Oct 2007 06:14:46 GMT

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

regards

shiba dutta