At 09:55 AM 30/09/2006, Adam wrote:

>Use semi colons where you want to include variables on the right hand
>side.

No, that's not the rule. The rule is that you use the colon prefix
wherever you refer to the variable in a DSQL statement, otherwise not.

>Assuming you meant.
>
>CODE_MEM = :CODE_MEM || :id_mem;

No. Would be
CODE_MEM = CODE_MEM || id_mem
or rather
CODE_MEM = coalesce(CODE_MEM,'') || id_mem;

./heLen