排序SQL ORDER BY查询，在转义字符前面没有斜杠

I am trying to figure out how to sort an SQL query by Last Name. This is working except in the case of where a customers last name has a special character.I am trying to figure out how to sort an SQL qu