SQL is using string comparison. You can use CAST to explicitly compare the version numerically. Here is my revision of the query:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tsysAssetTypes.AssetTypename As AssetType...