02-12-2008 10:03 AM
Hi,
Hello every body have a problem in using LIKE statement. I have written a BAPI to get the items according to the search criteria. Please advice, how can i pass my text to the select statement. At present i am passing the description like PIPE% from the front end.
SELECT * FROM TABLE WHERE DESCRIPTION LIKE DESCRIPTION.
I don't want to pass the description like PIPE% and the percentage symbol should be taken care in the back end.
Please help!
Kind Regards,
Rao (rao.busi@yahoo.com)
02-12-2008 10:09 AM
Hey this code is workinf fine. Check the same once.
DATA:
T_spfli TYPE TABLE OF spfli,
DESC TYPE SPFLI-CITYFROM VALUE 'NEW%'.
SELECT *
FROM spfli
INTO TABLE T_spfli
WHERE CITYFROM LIKE DESC.
02-12-2008 10:27 AM
Hi Jyothi,
Thanks. Please note that the search text will be passing from the front end, i.e. from portal. we never know what could the description. so we can't hard code the description like 'New'.
Please can you advice me, how can i pass the description to the select query.
Thanx,
Rao