Ghayaz Ghayaz - 4 months ago 6
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.


in microsoft SqlServer 2012, this will help you

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