An example of when the TRYCAST conversion fails:
SELECT TRYCAST('abc' AS DECIMAL(5,2));
Result:
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
TRYCAST('abc')
---------------
?
An example of when the TRYCAST conversion fails:
SELECT TRYCAST('abc' AS DECIMAL(5,2));
Result:
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
TRYCAST('abc')
---------------
?