At 05:37 PM 12/06/2007, you wrote:

>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 ?

You have the concatenation operator right but the syntax for the
SUBSTRING() function is wrong.

UPDATE PROJECTS
SET CODE = 'J.P.' || SUBSTRING(CODE from 1 for 3)

./heLen

Tip: MySQL isn't an ideal reference for standard SQL language. :-)