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.

A quick search of jobs containing "SQL" resulted in 400,000+ results. Meanwhile, a search for "Bigtable" resulted in 1,561 results, less than 1% of the SQL number.