Posted by othellomy on 11/21/06 11:51

select convert(float,'1.2334e+006')
1233400.0

select convert(decimal(20,2),'1.2334e+006')
Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.

can I set some options arithabort etc to have a workaround to this
problem?
Thanks.

• Next in forum: dynamic query
• Prev in forum: Re: Default Table Owner using CREATE TABLE, INSERT, SELECT & DROP TABLE
• Thread view: math error

[Reply to this message]