Error - View Single Post - Removing decimal places from a number SQL Server 2000

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

Question: 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:28 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 Question: 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. ------------------