Hi Eric,

try select Code1 || "." || Code2 as TheCode from MyTable

Uwe

Erik De Laet wrote:

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