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 ...

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

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.

Google's latest updates bring SQL to Bigtable and powerful new data features to Spanner, simplifying the integration of AI and enhancing the capabilities of global, scalable databases for enterprises.