Append an integer to a string as a string

Question

Trying to do something like this:

select 'Setup for Car ' + CAST(varchar(50), @CarID) + ' for user ' + CAST(varchar(5), @UserID)

doesn't work, not sure what the syntax would be then for T-SQL. I've hunted around, have not found it yet.

Taryn · Accepted Answer · 2012-06-18 14:52:13Z

2

You can user either of these:

select 'Setup for Car ' + Convert(varchar(50), @CarID) + ' for user ' + Convert(varchar(5), @UserID)

OR

select 'Setup for Car ' + CAST(@CarID as varchar(50)) + ' for user ' + CAST(@UserID as varchar(5))

answered Jun 18, 2012 at 14:52

Taryn

249k57 gold badges375 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

You can use either of of them, you just have to get the parameters in the correct location. :)

Justin Pihony · Accepted Answer · 2012-06-18 14:52:03Z

1

You are using CAST wrong. It should be

CAST(@Variable AS WhatYouAreCastingTo)

Remember, MSDN is your friend :)

answered Jun 18, 2012 at 14:52

Justin Pihony

67.2k20 gold badges154 silver badges185 bronze badges