topic Re: where condition in Application Development and Automation Discussions

where condition

Former Member — Tue, 19 Jun 2007 04:51:26 GMT

Hi,

From table KNVP i dont want to select the records starting with 9999.

I have written WHERE kunn2 <> '9999*'. Is this a valid condition?

Thanks,

Amol

Former Member — Tue, 19 Jun 2007 04:52:31 GMT

WHERE kunn2 not like '9999%'.

regards

shiba dutta

Former Member — Tue, 19 Jun 2007 04:53:41 GMT

Hi,

Use the following:

.... where KUNN2 like <> '9999%'.

Thanks,

Former Member — Tue, 19 Jun 2007 04:59:49 GMT

Hi,

Thanks a lot shiba.

Best Regards,

Amol