| Subject | RE: [firebird-support] How to concatenate strings in UPDATE statement ? |
|---|---|
| Author | Sasha |
| Post date | 2007-06-12T08:30:46Z |
> I've tried following query variants, but all of them report SQL error!Try this
>
> UPDATE PROJECTS SET CODE = 'J.P.' || SUBSTRING(CODE,3)
> UPDATE PROJECTS SET CODE = ('J.P.' || SUBSTRING(CODE,3))
> UPDATE PROJECTS SET CODE = 'J.P.' + SUBSTRING(CODE,3)
>
> Can anyone suggest a working solution ?
>
update projects set code = 'JP' || substring(code from 1 for 3)
Firebird Release Notes, page 28
Sasha