I have an address column however the ordering does not work when the address number goes above 10. i.e. address are ordered like so
1 address street
10 address street
2 address street
I am not guaranteed to know the length of the number of the street, nor if there will be one. To also complicate things the address could also be Flat 1, or Flat A, 1 Address Street.
I have been messing around with Patindex but it does not appear to be in SQL CE.
Anyone with any ideas?
View Complete Post