If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...

Arranging SQL data so that you can effectively analyze it requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that ...

I need to query against a column which contains build numbers stored as an NVARCHAR.<BR>Sorting works fine until you get into double-digit versions.<BR><BR>This works ...