you need.
Jim Davis
_____
From: Won Lee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 4:31 PM
To: CF-Talk
Subject: SQL: return only 2 decimal places
Hello,
Using SQL Server 2000.
I want to keep as much work on the SQL server.
I have a numeric value that I want to return as a 2 decimal place number.
10.98
1.34
03.45
.34
All valid returns. How can I do this? I can't run a substring on a
numeric value. Should I cast it then work on it? Shouldn't there be an
easier way?
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
