comparision parameter

[former_member611341]

may be this sound silly for u...

I need to get all customers starting with 'K' from KNA1

select kunnr from kna1 where matnr <b>??</b> ' K* '

what shud be the comparision parameter in select statement.

[former_member611341]

select kunnr from kna1 where matnr+0(1) eq ' K'

[Former Member]

select kunnr from kna1 where kunnr <b>LIKE</b> ' K<b>%</b> '

[former_member611341]

thanks...very much

i tried LIKE K* ...but didnt worked

[suresh_datti]

for wildacrd search in the where clause of a SELECT you have to use % & not *

~Suresh

[former_member611341]

i used after SRNIVAS told me...

intitally i was trying with 'k*'....

thanks srinivas and others too for quick response.....

[former_member611341]

thread closed

[Former Member]

select kunnr from kna1 where matnr+0(1) eq ' K'