Hi,
Could someone help me with quoting this right?
select into aliasvalue ''|| trim(arrayval[i]) ||'' from ''|| trim(realname) ||'' where ''|| trim(searchfield) ||'' like ''''%''|| trim(searchvalue) ||''%'''';
The parser does not seem to want to put the value of the variables into the statement.
Alex