microsoft.public.sqlserver.server

Author

CONVERT

2002-11-21, 1:23 am

Hi

DECLARE @CC VARCHAR(20)
SELECT @CC='9.2128536E-4'
SELECT CAST(@CC AS NUMERIC)

This command return an error "Error converting data type varchar to
numeric."

How can I convert values with Exp to numeric

Thanks in advance

Wilson

BlueGI

2002-11-21, 8:23 am

You can enter scientific notation as a number

DECLARE @CC float -- or whatever
SELECT @CC = 9.2128536E-4

"WT" <wilsontc@singnet.com.sg> wrote in message
news:#QPdkfSkCHA.1652@tkmsftngp11...
> Hi
>
> DECLARE @CC VARCHAR(20)
> SELECT @CC='9.2128536E-4'
> SELECT CAST(@CC AS NUMERIC)
>
> This command return an error "Error converting data type varchar to
> numeric."
>
> How can I convert values with Exp to numeric
>
> Thanks in advance
>
> Wilson
>
>

Sponsored Links