Ghayaz Ghayaz - 2 years ago 114
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
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download