SELECT ROUND(columnname, 2, 1) from tablename // 2 is decimal place
String.Format("{0:0.00}", 123.4567); // "123.46";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)