SELECT TRY_CAST(@abc AS VARCHAR(50)); Hello, World! 0x48656c6c6f2c20576f726c6421 SELECT CAST(@abc AS VARCHAR(50)); Hello, World! Hello, World! SELECT TRY_CONVERT(VARCHAR(50), @abc); Hello, World!