Originally posted by mber
Try to separate "%" out of the ":CTRBLK.CASE_NUMBER%" and use "||" to concatenate the "%".

HTH

Thanks

Hi,

I tried different ways to do that it doesn't show be error but it doesn't do what asked to do....

whereclause varchar2(80):='VW_CASEADDRESS_CASEMAIN.CSM_CASENO'||' '||'like'||' '||''':CTRBLK.CASE_NUMBER''''%''';

This is what I tried but it didn't work .....
how should I didplay normal where cluase