36 digit number

Hi I have this column numbers as varchars.
Length is 36
I need them to be numeric so I can run calcs on them
I can't find a datatype that allows that.
what the heck?
thanksTry with decimal.
Example:
declare @.d decimal (36, 0)
set @.d = 999999999999999999999999999999999999
select @.d
go
AMB
"Candor Feg" wrote:

> Hi I have this column numbers as varchars.
> Length is 36
> I need them to be numeric so I can run calcs on them
> I can't find a datatype that allows that.
> what the heck?
> thanks
>
>|||Lookup NUMERIC and DECIMAL data types in SQL Server Books Online.
Anith|||Just out of curiosity, what is being represented as a 36 decimal number?
"Candor Feg" <ddsd*f.com> wrote in message
news:i9KdnbbWotCeOAnfRVn-tA@.comcast.com...
> Hi I have this column numbers as varchars.
> Length is 36
> I need them to be numeric so I can run calcs on them
> I can't find a datatype that allows that.
> what the heck?
> thanks
>|||The chances of me being the antichrist.
"JT" <someone@.microsoft.com> wrote in message
news:%23lFGkfVYFHA.3132@.TK2MSFTNGP09.phx.gbl...
> Just out of curiosity, what is being represented as a 36 decimal number?
> "Candor Feg" <ddsd*f.com> wrote in message
> news:i9KdnbbWotCeOAnfRVn-tA@.comcast.com...
>