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

  • John Rowan,

    Thanks for that...I forgot about the decimal type. Too bad it returns 0 instead of 0.00. I can handle that in code, though

    Farrell,

    Yeah, just a display issue. I like dealing with data issues, even if it's just display, in SQL when I can. I can change a stored procedure on the fly without having to stop debugging, change the code, then recompile.

    Thanks to you both!

    Mike