Re: Best way to find string composed of dup character?

Woops - made a mistake :-)

This will find all WITHOUT duplicate digits :

> translate(p1.phone_number,'0','#') not like '%#######%' and
> translate(p1.phone_number,'1','#') not like '%#######%' and
> translate(p1.phone_number,'2','#') not like '%#######%' and
> translate(p1.phone_number,'3','#') not like '%#######%' and
> translate(p1.phone_number,'4','#') not like '%#######%' and
> translate(p1.phone_number,'5','#') not like '%#######%' and
> translate(p1.phone_number,'6','#') not like '%#######%' and
> translate(p1.phone_number,'7','#') not like '%#######%' and
> translate(p1.phone_number,'8','#') not like '%#######%' and
> translate(p1.phone_number,'9','#') not like '%#######%'

This will find those WITH duplicate digits :

translate(p1.phone_number,'0','#') like '%#######%' or
translate(p1.phone_number,'1','#') like '%#######%' or
translate(p1.phone_number,'2','#') like '%#######%' or
translate(p1.phone_number,'3','#') like '%#######%' or
translate(p1.phone_number,'4','#') like '%#######%' or
translate(p1.phone_number,'5','#') like '%#######%' or
translate(p1.phone_number,'6','#') like '%#######%' or
translate(p1.phone_number,'7','#') like '%#######%' or
translate(p1.phone_number,'8','#') like '%#######%' or
translate(p1.phone_number,'9','#') like '%#######%'

Sorry for the confusion.

/KiBeHa Received on Wed Feb 25 2004 - 09:00:09 CST