Jun 7, 2013, 2:30 PM
As is often the case, especially with SCCM, version numbers of applications and files are stored as strings (i.e., '7.0.90'). Depending on the software publisher, the version number may or may not be easily sortable in SQL Server. I've created a function that can be used in an ORDER BY clause to facilitate sorting of version numbers.