A quick expression to change an INT like 1234567 to a comma-separated NVARCHAR like '1,234,567'.
REPLACE(CONVERT(NVARCHAR, CONVERT(MONEY, CountPages), 1), '.00', '')
sounding - noun. 1. the act of taking a measure of depth
2. a probe of an environment
A quick expression to change an INT like 1234567 to a comma-separated NVARCHAR like '1,234,567'.
REPLACE(CONVERT(NVARCHAR, CONVERT(MONEY, CountPages), 1), '.00', '')
Larry Leonard | |
Larry@LarryLeonard.net | |
Lawrenceville, Georgia, United States | |
United States | |
Before making the move to SQL Server, Larry specialized in Windows programming in C/Win32, C++/MFC, and C#/.NET. His blog focuses on query tuning, database optimization, and system performance, and features handy scripts, practical tips, and occasional dispatches from the many dark corners of SQL Server. |
0 comments:
Post a Comment