Subject RE: Exact syntax to concatenate two fields as one
Author Mick Arundell
Erik

Select (Code1 || '.' || Code2) as TheCode

Mick


Hi,

I have two code fields in my table.
I want to select both of them with a '.' in between as one field.

Something like:
select Code1 + "." + Code2 as TheCode from MyTable

What is the exact syntax ?

Thanks,
Erik De Laet