Subject | Exact syntax to concatenate two fields as one |
---|---|
Author | Erik De Laet |
Post date | 2004-03-06T11:49:58Z |
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
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