-- 24254 tane cep gibi olmayan numara var, ancak yurtdışı cep olabilir,maximum char 18 select MusteriId, SUBSTRING(CepTelefon,1,5) from dsMusteri where CepTelefon not like '5%' and CepTelefon not like '05%' order by MusteriId select top 10 max(len(ceptelefon))DataLeng,CepTelefon from dsMusteri group by musteriId,CepTelefon order by max(len(ceptelefon))desc --is telefonu cep numarası olanlar 70845, max char 20 select MusteriId, SUBSTRING(IsTelefon,1,5) from dsMusteri where IsTelefon like '5%' or IsTelefon like '05%' order by MusteriId select top 10 max(len(IsTelefon))DataLeng,IsTelefon from dsMusteri group by musteriId,IsTelefon order by max(len(IsTelefon))desc --ev telefonu cep gibi olanlar 144274, max evtelefon char 20 select MusteriId, SUBSTRING(EvTelefon,1,5) from dsMusteri where EvTelefon like '5%' or EvTelefon like '05%' order by MusteriId select top 10 max(len(EvTelefon))DataLeng,EvTelefon from dsMusteri group by musteriId,EvTelefon order by max(len(EvTelefon))desc
