according to this example though...

it looks as though it specifies only one record.

set @var = 132456789.12552346

thats fine cause i can concat the entire script

against every records (few million rows), then...

quick recap

declare @var float

set @var = 132456789.12

select cast(@var as decimal(11,2))

i'm setting it up like this though i doubt it will work.

declare @var float

set @var = (table.column)

select cast(@var as decimal(11,2))

ideas?

here's the situation.

i have a few million records that currently exist as a float which i need converted to

decimal (25, 10) datatype, but whenever converted from Management Studio or

Enterprise...

thanks for the reply...

unfortunately it still errors out with the arithmetic overflow error.

this is really unusual.