How to combine separate fields into one

Database
Fan

How to combine separate fields into one

How does one combine 2 separate fields in a SELECT statement? I'm trying to combine 2 separate fields to create a new key field (separated by a dash) as part of the output data.
2 REPLIES
Enthusiast

Re: How to combine separate fields into one

Use the string concatenation operator:

select trim(a) || '-' || trim(b) as combo from t1;

combo
------------
19-0
Fan

Re: How to combine separate fields into one

Thank you - the solution worked great and will save me extra steps in my Access analysis.

Gerry.