Subject Re: [ib-support] Concatination?
Author Doug Chamberlin
At 8/14/2001 01:59 PM (Tuesday), Joe Martinez wrote:
>I'm trying to find an SQL statement that will prepend a string to a
>field for a certain set.

If the column is a CHAR or VARCHAR try the concatenation operator, ||,
instead of +.

update mytable set mycolumn = ('100' || mycolumn) where...