HOME

Thursday, December 29, 2011

Alphanumeric sorting in sql server 2005

elect SectionNumber from tableName order by Left(replicate('0',20) + SectionNumber, 20)

No comments:

Post a Comment