Solved: Re: query

Former Member · ‎2006 Dec 11

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 · ‎2006 Dec 11

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 · ‎2006 Dec 11

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 · ‎2006 Dec 11

thanx for u r replies

senthil

Former Member · ‎2006 Dec 11

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