John

John

  • NA
  • 928
  • 131k

Sort in sql server

Aug 1 2016 7:49 AM
how can i sort this no. 
Web\372\15-16 
Web\45\16-17 
Web\01\15-16 
Web\371\15-16  
 
according to this
Web\45\16-17  
Web\372\15-16
Web\371\15-16
Web\01\15-16
 
(In this 16-17 defines the year) 

Answers (7)