I would like to include this column in a Select statement, convert it to a Varchar and only display two decimal places. I can't seem to find the ... ... <看更多>

(If you are using SQL Server 2012 or newer, please see @wBob's answer for a cleaner approach. The approach outlined in my answer below is ... ... <看更多>

STR converts a number to a string, and you can specify the total length and the number of decimal places. The FORMAT function gives you a ... ... <看更多>