select  SUBSTRING(t1.xhdwswjgdm,1,7) as fild from xx;  //截取前7位