Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: johnnymagee69
- Content: Threads
- Order by date
-
Rounding in functions
Hi, I'm getting some strange answers when using round(). If I just use a single query select round(20.6348035,6) correctly rounds up and returns 20.634804. However when called as part of a stored procedure round(20.6348035,6) rounds down and returns 20.634803. Has anyone got any idea why...- johnnymagee69
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
Round up to 8 sig fig
Hi, I have to re-create in SQL a custom Excel function which rounds numbers to 8 significant figures (because thats how many digits can be shown on a calculator!). I can work out the number of decimal points correctly but the round() function then rounds down when called in a procedure instead...- johnnymagee69
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Xtal 11 - Trimming varchar
The Xtal report shows all clauses for a contract with a subreport that show each contract clause. This subreport consists of a single field - 'clausetext' of type varchar(1024). But...each clausetext can be of different length. How can I eliminate the whitespace at the end of each clause so...- johnnymagee69
- Thread
- Replies: 8
- Forum: Business Objects: Crystal Reports 4 Other topics
