2. ASPRunnerPro General questions
  3. Concatenating 2 columns into one
This topic is locked

Concatenating 2 columns into one

 		3/21/2010 8:03:26 PM
ASPRunnerPro General questions
S
 suprapen author

I tried to do this using the Query Designer and didn't work out.
(dbo.table1.field1 + '' + dbo.table1.field2) AS field3
Sergey Kornilov admin 3/21/2010

What database do you use?
S
 		suprapen author 3/21/2010



What database do you use?


MSSQL Server 2005
Sergey Kornilov admin 3/22/2010

Then syntax you use is correct and should work. Probably you need to what 'didn't work out' means.