Wednesday, October 17, 2012

Quick Tip #1

Converting a INT to VARCHAR trims all leading zeros

SELECT CONVERT(VARCHAR, 00012345)


No comments:

Post a Comment