用CHARINDEX 算出逗号排在第几个字符,然后用substring 截取:select substring ('信息处，生产监督信息处',1,CHARINDEX(',','信息处，生产监督信息处')-1)
select plan_id,[name],a from v_plan where a like '信息处%'
