My data is in this way 

```
<400    
1000-1200    
1200-1400    
1400-1600    
1600-1800    
400-600    
600-700    
700-800    
800-1000

```

And I want this way 

```
<400    
400-600    
600-700    
700-800    
800-1000    
1000-1200    
1200-1400
...

```

```
 order by   LEFT(WC.[WGHT_CLAS_DESC], PATINDEX('%[0-9]%', WC.[WGHT_CLAS_DESC])-1), 
    CONVERT(INT, SUBSTRING(WC.[WGHT_CLAS_DESC], PATINDEX('%[0-9]%', WC.[WGHT_CLAS_DESC]), LEN(WC.[WGHT_CLAS_DESC])))

```

This is the code I have used in SQL Server but its not working