Home Forums SQL Server 2012 SQL Server 2012 - T-SQL select house_no order RE: select house_no order
Lynn Pettis
SSC Guru
Points: 442467
More actions
December 15, 2013 at 8:57 am
#1673537
Since your data is character based and inconsistent, you are going to need to figure out a way to parse/transform the data into a consistent format that can be sorted.
Not sure based on the sample data if that fully represents all of your data.