Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

where condition

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

WHERE kunn2 not like '9999%'.

regards

shiba dutta

3 REPLIES 3

Former Member
0 Kudos

WHERE kunn2 not like '9999%'.

regards

shiba dutta

0 Kudos

Hi,

Thanks a lot shiba.

Best Regards,

Amol

Former Member
0 Kudos

Hi,

Use the following:

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

Thanks,