Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8551
  • Last Modified:

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.
0
JElster
Asked:
JElster
1 Solution
 
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
 
Ephraim WangoyaCommented:
Use convert

SELECT   CONVERT(numeric(6, 2), column)
from Table
WHERE  ISNUMERIC(column) = 1
0
 
marlon espanolaCommented:
cc03e747a6afbbcbf8be7668acfebee5 can you convert this to numeric? please .... thanks
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now