|
|
Posted by Madhivanan on 11/23/06 13:55
othellomy@yahoo.com wrote:
> 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.
Try
select convert(decimal(20,2),1.2334e+006)
Madhivanan
Navigation:
[Reply to this message]
|