Re: Oracle Forms Search String

Try this:
Set_Block_Property ( 'blk_name', Property_name,

        'Where value like ''%PATERN%''');

Into the string, you need two quotes to get one.

An easy example is (in sqlplus):
select '''' from dual;
This returns a single-quote.

--
Julio César Glez Suarez
Xixón, Asturies, Spain
jgonzalezsuareNO_at_SPAMnexo.es (Remove NO SPAM)