Round Off float value to 2 decimal places - MSDN - Microsoft

I have a requirement in SQL Server. Say I have a value, 178.6999. I need this to be shown as 178.70. I tried 'select CAST(ROUND(178.6999, 2) ...

www.google.com.tw