Home Forums SQL Server 7,2000 T-SQL Select statement to reduce precision? RE: Select statement to reduce precision?

  • November 16, 2006 at 11:53 am

    #672396

    You're going down the right path, but try using decimal data type and setting the precision and scale.  For example,

     

    declare @money money

    set @money = 150.2315

    select CAST(@money as decimal(18,2))

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden