sql server covert number to 2 decimal places code example Example: sql decimal to 2 places CAST(MyNumber AS NUMERIC(18,2))