Re: Using a variable in SQL with an Update statement

dgmyrs@my-deja.com wrote: > Use something like: > > Update Table printtab > Set prcommand = prcommand || ' -olandc' > Where 1=1; The above is fine if prcommand is a VARCHAR; if its a CHAR, it needs to be TRIMmed appropriately. For example, update printtab set prcommand = trim(prcommand) || '-olandc' where ... Rudy