| Subject | Re: [ib-support] Concatination? |
|---|---|
| Author | Joe Martinez |
| Post date | 2001-08-14T19:27:43Z |
> If the column is a CHAR or VARCHAR try the concatenation operator, ||,That was it! Thanks!
> instead of +.
>
> update mytable set mycolumn = ('100' || mycolumn) where...
-Joe