Post reply

Inserting Decimals

  • 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

  • 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