|
|
Posted by Helmut Woess on 11/22/06 14:36
Am 21 Nov 2006 22:09:05 -0800 schrieb othellomy@yahoo.com:
> 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.
>
> Is there any way around?
> Is there any set options? I tried arithabort or arithignore and they
> don't work.
> Thanks.
select convert(decimal(20,2),cast('1.2334e+006' as float))
bye,
Helmut
Navigation:
[Reply to this message]
|