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

Another way of doing the same thing for SQL is to make a column for sorting and pad all numbers with zeros. So, 12R57B will become 0000012R0000057B.

SQL is the tool you need to reach useful conclusions regarding voluminous reports and vast databases. Get this SQL training instruction, for only $15.