Text copied!
TRY_CONVERT function
In SQL, TRY_CONVERT function is used to convert a value from one data type to another data type and handle errors by returning NULL if a cast operation fails.
The syntax of the TRY_CONVERT function generally looks like this :
TRY_CONVERT(data_type, expression)
• Specify the 'expression/value' that you want to convert from one data type to another.
• Specify the desired 'data type' to which you want to convert the value or expression.
Here's an example of how you might use the TRY_CONVERT function :
1. Let's assume we have a table named "[Employees]".
2. Let's assume you want to convert the Employee_Name values into 'INT' data type, which doesn't make sense. However, this example illustrates that the CONVERT function will raise an error when attempting this conversion, while the TRY_CONVERT function will not throw an error and will instead return NULL as the result.
3. Run below SQL statement :
SELECT *, TRY_CONVERT(INT, Employee_Name) AS [Date]
FROM [Employees];
4. In above statement, TRY_CONVERT function tries to convert the Employee_Name values into 'INT' data type and returns NULL if conversion fails.
Remember :
Using this function in a select statement won't modify the [Employees] table directly, but it will only be reflected in the select statement's output.