SELECT *,substring(字段名,1,patindex('%[^0-9]%',字段名)-1) FROM 表名 转载于:https://www.cnblogs.com/CoffeeEddy/p/11218052.html