This is simple function which can format a given number as Comma delimited number. ex : 98712345 as 98,712,345 Thanks to (Attached is the original code which works on SQL Server 2000 and SQL Server 2005.) (download) formatnumber I have slightly modified it for SQLServer 2005. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO — =============================================… (1 comment)