<div>
It has to do with formatting. &nbsp;For example, Excel allows negative numbers to be represented as (123456) and thousands as 123,456. &nbsp;SQL Server is not so forgiving.<br />
<br />
You are going to have to roll up your sleeves and identify the culprit and fix it.
</div>


It has to do with formatting.  For example, Excel allows negative numbers to be represented as (123456) and thousands as 123,456.  SQL Server is not so forgiving.

You are going to have to roll up your sleeves and identify the culprit and fix it.

<div>
Perfect...thank you. It was the xdmp.[fms #] field that was the float. A quick CAST to a VARCHAR and everything ran great.
</div>


Perfect...thank you. It was the xdmp.[fms #] field that was the float. A quick CAST to a VARCHAR and everything ran great.

<div>
<div class="content wysiwyg-content">
I am getting the following error when trying to run an update query: Error Converting Data Type Varchar to Float. Here is the code I'm using...<br />
<br />
begin tran<br />
<br />
update TB_PARTS<br />
set COST = xdmp.new_cost<br />
--set COST = case isnumeric(xdmp.new_cost) when 1 then cast(xdmp.new_cost as FLOAT) else null end<br />
from TB_STYLES<br />
join TB_PARTS on TB_STYLES.STYLE_ID = TB_PARTS.STYLE_ID<br />
join xdmp on TB_STYLES.STYLE = xdmp.[fms #]<br />
where <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_PARTS.CONTACT_ID = 23<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
rollback<br />
commit<br />
<br />
The data in the xDMP table was imported from an Excel spreadsheet using DTS. The data types for the TB_PARTS.COST field and the xDMP.New_Cost are both showing FLOAT. <br />
<br />
Not sure what I'm doing wrong. any suggestions to help fix the issue would be great.<br />
<br />
Thanks.
</div>
</div>


I am getting the following error when trying to run an update query: Error Converting Data Type Varchar to Float. Here is the code I'm using...

begin tran

update TB_PARTS
set COST = xdmp.new_cost
--set COST = case isnumeric(xdmp.new_cost) when 1 then cast(xdmp.new_cost as FLOAT) else null end
from TB_STYLES
join TB_PARTS on TB_STYLES.STYLE_ID = TB_PARTS.STYLE_ID
join xdmp on TB_STYLES.STYLE = xdmp.[fms #]
where 
	TB_PARTS.CONTACT_ID = 23
	
rollback
commit

The data in the xDMP table was imported from an Excel spreadsheet using DTS. The data types for the TB_PARTS.COST field and the xDMP.New_Cost are both showing FLOAT. 

Not sure what I'm doing wrong. any suggestions to help fix the issue would be great.

Thanks.

Error converting data type varchar to float

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.