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 fine:<BR>1.1.1234.0<BR>1.1 ...

Is it possible to order by a substring in a returned field ... I can't think of how I'd do this in SQL, but before I give up and just write code to deal with it, can someone else come up with ...