where condition

[Former Member]

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]

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]

WHERE kunn2 not like '9999%'.

regards

shiba dutta

[Former Member]

Hi,

Thanks a lot shiba.

Best Regards,

Amol

[Former Member]

Hi,

Use the following:

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

Thanks,