I need to query against a column which contains build numbers stored as an NVARCHAR.Sorting works fine until you get ... but I'm not sure how to tell SQL to sort a text field like that.<BR><BR>Is ...

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.

Joey on SQL Server. A Deep Dive into SQL Server 2022's Query Performance Features, Part 1. An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to ...