<div>
Can you post your query so we can see the details? &nbsp;Thanks!
</div>


Can you post your query so we can see the details?  Thanks!

<div>
UPDATE revenue SET PERCENTAGE = CAST([PERCENT] AS NUMERIC(6,2))
</div>


UPDATE revenue SET PERCENTAGE = CAST([PERCENT] AS NUMERIC(6,2))

<div>
cc03e747a6afbbcbf8be7668ac<wbr />febee5 can you convert this to numeric? please .... thanks
</div>


cc03e747a6afbbcbf8be7668acfebee5 can you convert this to numeric? please .... thanks

<div>
<div class="content wysiwyg-content">
How do I convert a varchar to a numeric 6,2<br />
<br />
&quot;50.00&quot;<br />
&quot;100.00&quot;<br />
<br />
I tried cast but get ...<br />
<br />
Msg 8114, Level 16, State 5, Line 2<br />
Error converting data type nvarchar to numeric.
</div>
</div>


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.

SQL SERVER - Convert varchar to numeric 6.2

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.