I am trying to concat two non sting fields.
For example :

(Dbo.Id) +''+(dbo.ReportsId)
300 5 = 3005

but I am getting the addition of these two (305) instead of them being appended to each other(3005).
I have tried Cast and converting the values from int to varchar but it still adds them.

Any advice?


Sincerely,

Justin Gilli








MS Sql Server LazyDBA home page