SELECT TRYCAST('-2.5' AS DECIMAL(5,2));
Result:
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
TRYCAST('-2.5')
---------------
-2.50
SELECT TRYCAST('-2.5' AS DECIMAL(5,2));
Result:
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
TRYCAST('-2.5')
---------------
-2.50