Ghayaz Ghayaz - 1 year ago 67
SQL Question

How to convert Decimal Column into varchar in sql

I am joining two tables in which i am concatenating 4 columns as single column so in the four columns 3 columns are decimal and one is varchar but my requirement is to display as a string column in the U.I Please advise.

Answer Source

in microsoft SqlServer 2012, this will help you

 SELECT CONVERT(varchar(10),ColumnName) "newColumnName" FROM   tableName