gent
SSC Journeyman
Points: 85
More actions
July 6, 2009 at 9:50 am
#211880
I have a column of data, but need to extract it with the with a decimal in the string of numbers.
For example I have 425699, when I extract it I would like to see 4256.99
Is that possible with SQL?
Thanks
Lynn Pettis
SSC Guru
Points: 442467
July 6, 2009 at 9:52 am
#1020473
This?
declare @TestInt int;
set @TestInt = 425699;
select cast(@TestInt/100.00 as decimal(10,2);
July 6, 2009 at 10:00 am
#1020481
Thank you. it worked out perfectly.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply