CODEWITHSUNDEEP
sql-server
shoakat
shoakat

Reputation: 41

Error converting data type varchar to numeric

Update table set Test = Convert(varchar(53), Cast(Phone_Number as Decimal))

Upvotes: 2

Views: 3975

Answers (1)

KM.
KM.

Reputation: 103697

if Phone_Number has any alphabetic or symbol characters it will fail when CASTing it to DECIMAL:

Update table set Test = Convert(varchar(53), Cast(Phone_Number as Decimal))
                                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Your question is very vague, but you could try:

Update YourTable
    SET Test=CASE 
                 WHEN ISNUMERIC(Phone_Number)=1 THEN Convert(varchar(53), Cast(Phone_Number as Decimal)) --this is your code unchanged
                 ELSE Phone_Number
             END
...

Upvotes: 3

Related Questions