Sorting Build #’s, IP Addresses

You can use this T-SQL statement to sort your build or IP addresses stored in your database.

SELECT * FROM ApplicationUpdates
ORDER BY
CAST(PARSENAME(UpdateAppVersion, 4) AS INT),
CAST(PARSENAME(UpdateAppVersion, 3) AS INT),
CAST(PARSENAME(UpdateAppVersion, 2) AS INT),
CAST(PARSENAME(UpdateAppVersion, 1) AS INT)

SortedNot Sorted
1.1.0.11.1.0.1
1.1.0.21.1.0.10
1.1.0.31.1.0.2
1.1.0.41.1.0.3
1.1.0.51.1.0.4
1.1.0.61.1.0.5
1.1.0.71.1.0.6
1.1.0.81.1.0.7
1.1.0.91.1.0.8
1.1.0.101.1.0.9

Moving again!!!

Boy this moving business is for the birds, this is like the 3rd time I have moved or drastically changed my blog in the last 2 months. So far I am very happy with WordPress.com and I think I’m here to stay. WordPress is by far the best blogging engine I have used/seen to date.

Now if I can get them to map my domain instead of me doing a redirect I’ll really be happy.