Lee,

> Thanks Lucas, yes I think that works when I use a constant. Any idea on how
> to do this when the 'abc_def' part needs to come from a table value?

what about SELECTing it?

declare variable myvar sometype;
...
select somefield from sometable where <unique condition> into :myvar;
--
____
_/\/ando