/*
To fix this, you’d need to make sure you provide a value that SQL Server can convert.
If you’re passing a column, check that you’ve got the right column. Same if you’re passing a variable – check that it’s the right variable.
Bear in mind that this might not happen in all cases of trying to convert a string to decimal, because some string values can be converted.
For example, the following conversion succeeds:
*/
select select cast('10' as decimal(5,0)); /* output	10.00 */
/*
If you don’t mind the conversion failing, but you just don’t want it to return an error, try the TRY_CAST() or TRY_CONVERT() functions.
Rather than return an error, these functions return NULL when the value can’t be converted.
*/
Example:
SELECT TRY_CAST('Ten' AS DECIMAL(5,2)); /* output	null */