error converting data type varchar to numeric. sql server

Abdullrhman elhelw answered on February 22, 2023 Popularity 8/10 Helpfulness 4/10

answer error converting data type varchar to numeric. sql server

error converting data type varchar to numeric. sql server

Comment

/*
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
 */

Popularity 8/10 Helpfulness 4/10 Language sql

Source: database.guide

Tags: sql sql-server varchar

Link to this answer
Share Copy Link

Contributed on Feb 22 2023

Abdullrhman elhelw

0 Answers Avg Quality 2/10

error converting data type varchar to numeric. sql server

Contents

More Related Answers

error converting data type varchar to numeric. sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.