Sorting data having greater than and lesser than signs

Question

I have data in my table something like this <-3 <-2 <-1 0 1 2 3 >3 >4 11,12,6,9,-4,-6,-9, <-7 etc

so what i want is a query that will give me the result some thing like this

-9,<-7,-6,-4, <-3 <-2 <-1 0 1 2 3,>3,>4,6,9,11,12...

Answer 1

Something like this should work:

use tempdb            
go            
declare @vals table (val varchar(100))            
            
insert @vals            
values ('>-1')            
            
insert @vals            
values ('<-3')            
            
insert @vals            
values ('<3')            
            
insert @vals            
values ('>1')            
            
select val, replace(replace(val, '<', ''), '>', '')            
from @vals            
order by CAST(replace(replace(val, '<', ''), '>', '') AS INT)

You can use the REPLACE function to strip out the greater than and less than signs and then convert to an integer.

Sorting data having greater than and lesser than signs

Follow this question

Related Questions