Removing decimal places from a number SQL Server 2000

**Anilrgowda** · 22-Oct-2007, 12:39 AM

Is there a way to force a number to display without decimals in SQL Server 2000? If not, a way in crystal reports to do the same? I tried setting the decimal places to 0 in Crystal reports and I still see 2 decimal places.

**Anilrgowda** · 22-Oct-2007, 12:40 AM

Depends how you want to remove the decimal places. If you want to round DOWN to the nearest whole number, use the FLOOR function. FLOOR(113.23) will return 113

If you want to ROUND UP to the nearest whole number use CEILING. CEILING(113.32) will return 114

If you want to round up OR down depending on the size of the decimal part, use the ROUND function. ROUNG(112.23) will return 112 and ROUND(112.89) will return 113

22-Oct-2007, 12:39 AM	#1 (permalink)
Anilrgowda Administrator Posts: 18,715 Join Date: Jan 2006 Rep Power: 10 IM:	Removing decimal places from a number SQL Server 2000 Is there a way to force a number to display without decimals in SQL Server 2000? If not, a way in crystal reports to do the same? I tried setting the decimal places to 0 in Crystal reports and I still see 2 decimal places. ------------------

22-Oct-2007, 12:40 AM	#2 (permalink)
Anilrgowda Administrator Posts: 18,715 Join Date: Jan 2006 Rep Power: 10 IM:	Re: Removing decimal places from a number SQL Server 2000 Depends how you want to remove the decimal places. If you want to round DOWN to the nearest whole number, use the FLOOR function. FLOOR(113.23) will return 113 If you want to ROUND UP to the nearest whole number use CEILING. CEILING(113.32) will return 114 If you want to round up OR down depending on the size of the decimal part, use the ROUND function. ROUNG(112.23) will return 112 and ROUND(112.89) will return 113 ------------------

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)