Re: [SQL] Sorting router interfaces

2010-11-01 Thread Andreas
Am 01.11.2010 13:15, schrieb Brian Sherwood: I am trying to sort router interface names. The problem is that I am doing a text sort and need to do a numerical sort. What I get instead is the following text ordering: GigabitEthernet1/0/1| 1/0/1 | {1,0,1} GigabitEthernet1/0/10 | 1/

Re: [SQL] Sorting router interfaces

2010-11-01 Thread Filip Rembiałkowski
2010/11/1 Brian Sherwood : > I am trying to sort router interface names. > The problem is that I am doing a text sort and need to do a numerical sort. > > I want the interfaces to be in numerical order: > >  GigabitEthernet1/0/1    | 1/0/1 | {1,0,1} >  GigabitEthernet1/0/2    | 1/0/2 | {1,0

[SQL] Sorting router interfaces

2010-11-01 Thread Brian Sherwood
I am trying to sort router interface names. The problem is that I am doing a text sort and need to do a numerical sort. I want the interfaces to be in numerical order:  GigabitEthernet1/0/1    | 1/0/1 | {1,0,1}  GigabitEthernet1/0/2    | 1/0/2 | {1,0,2}  GigabitEthernet1/0/3    | 1/0/3