what are you looking to end up with if the value that you start with is
0.000025

tony.

-----Original Message-----
From: Kristen Winsor [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 9:16 AM
To: CF-Talk
Subject: Using ABS in CF 5

Why would 3E-005  be shown when using
#abs(NumberFormat(getRate.Rate)'_.__________'))#?

instead of  0.000025, which is the value in the db (and the value returned
when Select ABS(.000025) is run)

If I take the abs away, the number is shown correctly...?

Thanks
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to