declare @sUnitInfoID varchar(100) set @sUnitInfoID = '23,15,14' select * from EHistoryData a where charindex(','+rtrim(UnitInfoID)+',',','+(@sUnitInfoID)+',') > 0
如果查询出的字段值为'23,15,14' select ID from UnitInfo where Area='福田区'
select * from EHistoryData a where charindex(','+rtrim(UnitInfoID)+',',','+(select ID from UnitInfo where Area='福田区')+',') > 0