topic comparision parameter in Application Development and Automation Discussions

comparision parameter

former_member611341 — Thu, 31 May 2007 22:25:40 GMT

may be this sound silly for u...

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

select kunnr from kna1 where matnr ?? ' K* '

what shud be the comparision parameter in select statement.

Former Member — Thu, 31 May 2007 22:26:48 GMT

select kunnr from kna1 where kunnr LIKE ' K% '

former_member611341 — Thu, 31 May 2007 22:27:59 GMT

thanks...very much

i tried LIKE K* ...but didnt worked

former_member611341 — Thu, 31 May 2007 22:28:39 GMT

thread closed

Former Member — Thu, 31 May 2007 22:28:44 GMT

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

suresh_datti — Thu, 31 May 2007 22:29:47 GMT

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

~Suresh

former_member611341 — Thu, 31 May 2007 22:31:00 GMT

i used after SRNIVAS told me...

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

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