Posted by markc600 on 11/16/06 21:30

Here are a couple of ways

SELECT ROUND(170,0)
SELECT ROUND(96.58,0)

SELECT CAST(170 AS DECIMAL(10,0))
SELECT CAST(96.58 AS DECIMAL(10,0))

• Next in forum: Re: newbie: telnet localhost 1433 fails
• Prev in forum: round to nearest WHOLE number
• Thread view: Re: round to nearest WHOLE number

[Reply to this message]