SQL SERVER - Convert varchar to numeric 6.2

How do I convert a varchar to a numeric 6,2

"50.00"
"100.00"

I tried cast but get ...

Msg 8114, Level 16, State 5, Line 2
Error converting data type nvarchar to numeric.
LVL 1
JElsterAsked:
Who is Participating?
 
Ephraim WangoyaConnect With a Mentor Commented:
Use convert

SELECT   CONVERT(numeric(6, 2), column)
from Table
WHERE  ISNUMERIC(column) = 1
0
 
didnthaveanameCommented:
Can you post your query so we can see the details?  Thanks!
0
 
JElsterAuthor Commented:
UPDATE revenue SET PERCENTAGE = CAST([PERCENT] AS NUMERIC(6,2))
0
 
marlon espanolaCommented:
cc03e747a6afbbcbf8be7668acfebee5 can you convert this to numeric? please .... thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.