Concatenate a Varchar and int

Question

I need to Concatenate a Varchar and int in T-SQL , !

As in this http://stackoverflow.com/questions/3150943/combine-varchar-column-with-int-column? — ig0774, Feb 05 '11 at 05:27

score 67 · Accepted Answer · answered Feb 05 '11 at 05:27

67

SELECT ('VarValue' + CAST(32 AS VARCHAR))

answered Feb 05 '11 at 05:27

Brian

It's a best practice to declare VARCHAR variables / parameters with a length. See for example: https://sqlblog.org/2009/10/09/bad-habits-to-kick-declaring-varchar-without-length – Jon Schneider Mar 20 '14 at 19:03

score 8 · Answer 2 · edited May 24 '16 at 16:07

8

varcharName + cast(intName as varchar) as full_name

Should do it

edited May 24 '16 at 16:07

answered Feb 05 '11 at 05:28

Ralph

2 Answers2