It may not make much sense to do this right now, but it is vital to the way in which our Bubble Sort algorithm works. (The example in this article applies to SQL Server 2000 and later.) ...

The other entry in those cases has 0 in its range columns.<BR><BR>I want to have the ranges outputted in a sorted order. When the street is not split, sorting by the FromLeft column works great.