select * from 表 where tel like '%025%' or fax like '%025%' or email like '%025'
基本的查询语句!!好好学习sql.
where (charindex('025',p.tel)>0 and (charindex('025',p.fax)>0 and (charindex('025',p.emial)>0 或者 where (patindex("%"+'025'+"%",p.tel)>0 and (patindex("%"+'025'+"%",p.fax)>0 and (patindex("%"+'025'+"%",p.emial)>0
and (charindex('025',p.fax)>0
and (charindex('025',p.emial)>0
或者
where (patindex("%"+'025'+"%",p.tel)>0
and (patindex("%"+'025'+"%",p.fax)>0
and (patindex("%"+'025'+"%",p.emial)>0