Skip to Content
0
Former Member
Dec 11, 2006 at 01:16 PM

query

22 Views

hello gurus,

I am having an text in the input fiedl based on that i

am searching the fields

I ant to use the %

how can i retirieive it based ont that

CONCATENATE '%' reason_text '%' INTO reason_text.

SELECT * FROM table INTO CORRESPONDING FIELDS OF TABLE close_reason

WHERE reason_text CP reason_text.

it throws an error meesage

how can i do it

senthil