I am using Firebird 2.0.1 (on Windows) and I am having a following SQL
problem:

I have to port following SQL that works fine on Mysql:

UPDATE PROJECTS SET CODE = CONCAT('J.P.', SUBSTRING(CODE,3))

It seems that there is no CONCAT method in Firebird, so I've run
google search to see what operator could I use for this

I've tried following query variants, but all of them report SQL error!

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 ?

TIA.

Regards,
Miroslav