Simple Concatenation Question
am 02.04.2008 15:44:44 von t8ntboyHere's what I have:
SELECT (Term + CRN) AS Comb
FROM dbo.SAS
Both Term and CRN are Int fields.
When it concatenates it is adding the values together.
For example:
Term CRN Comb
5 18 23
6 11 17
What I want is:
Term CRN Comb
5 18 518
6 11 611
How can this be done?
Thanks