select SUBSTRING(jingdu,CHARINDEX(',',jingdu)+1,1000) as jingdu ,SUBSTRING(weidu,1,CHARINDEX(',',jingdu)-1) as weidu from 表名
