Ghayaz Ghayaz - 5 months ago 10
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

in microsoft SqlServer 2012, this will help you

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