SQL sorts string numbers

background ：

Because of the needs of the project , You need to sort string numbers

Method 1 ：

• principle ： Sort strings with the same length first , Then according to the string ASCII Sort code .

• SQL sentence ：

  SELECT 
  	transactionGmv6Months 
  FROM 
  	company 
  WHERE 
  	categoryId=127726077
  ORDER BY 
  	LENGTH(transactionGmv6Months),transactionGmv6Months;
  

• Query results ：
  

Method 2 ：

• principle ： Remove unnecessary characters from the string first , Then convert to numeric type for sorting 【 recommend 】.
• SQL sentence ：

  SELECT 
  	transactionGmv6Months 
  FROM 
  	company 
  WHERE 
  	categoryId=127726077
  ORDER BY 
  	CONVERT(REPLACE(REPLACE(transactionGmv6Months,'+',''),',',''),SIGNED) DESC
  

• Query results ：