In SQL, how to concatenate string with integer data type column

Question

I am trying to add string "Rs" with amount column. The data type of amount is integer. But Sql is not allowing me to concatenate string with int data type column.Image 1

Image 2

Pரதீப் · Accepted Answer · 2017-07-23 16:03:04Z

20

You need to explicitly convert the int to varchar before concatenating with any string

select 'RS'+cast(total_amount as varchar(100)),*
from yourtable

If you are sql server 2012+ then use CONCAT which does implicit conversion

select Concat('RS',total_amount),*
from yourtable

answered Jul 23, 2017 at 16:03

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

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

1 Comment

Saqib Over a year ago

Thank you so much!

Collectives™ on Stack Overflow

In SQL, how to concatenate string with integer data type column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related