Re: Rounding number format to 0 decimal places

[Joe Rinehart]

If you need it at the query level, you can do:

SELECT CAST(columnToBeInt AS INT)

Otherwise, the numberFormat() can do wonders when it comes to, well,
formatting numbers.

-joe

----- Original Message -----
From: Mark Henderson <[EMAIL PROTECTED]>
Date: Fri, 6 Aug 2004 10:42:29 +1200
Subject: RE: Rounding number format to 0 decimal places
To: CF-Talk <[EMAIL PROTECTED]>

hi Charlie,
int() might work. But then I thought round would too. I'm just not
sure how to build it into the resulting output query.

regards
Mark________________________________

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---