Sort Alphanumeric Values in SQL Server

(Jeffrey Yao) In my work I sometimes need to import csv files and one column of the csv file is an alphanumeric string, with values like the following:

Register to Read