--- In firebird-support@yahoogroups.com, "Sasha" <selectnull@...> wrote:

> Try this
> update projects set code = 'JP' || substring(code from 1 for 3)
>
> Firebird Release Notes, page 28
>
> Sasha

Thanks everyone for the help. The working version is actually:

update projects set code = 'JP' || substring(code from 3)

Regards,
Miroslav