topic query in Application Development and Automation Discussions

query

Former Member — Mon, 11 Dec 2006 13:16:54 GMT

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

Former Member — Mon, 11 Dec 2006 13:20:46 GMT

HI Senthil

For Patterns: Use LIKE for comparision.

Eg:

select fld1 fld2.... into table itab
     from <itab>
     where fld1 LIKE 'PAT%'.

In your case it should be:

CONCATENATE '%' reason_text '%' INTO reason_text.

SELECT * FROM table INTO CORRESPONDING FIELDS OF TABLE close_reason

WHERE reason_text <b>LIKE</b> reason_text.

Kind Regards

Eswar

Former Member — Mon, 11 Dec 2006 13:21:31 GMT

Hi Senthil,

You could make use of the LIKE addition in the SELECT statement,

SELECT * FROM table INTO CORRESPONDING FIELDS OF TABLE close_reason

WHERE reason_text LIKE reason_text.

Please make your queries more informative

Regards

Wenceslaus

Former Member — Mon, 11 Dec 2006 13:24:07 GMT

thanx for u r replies

senthil