Bubbler numbers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Web Applications Meta

Q&A about the site for power users of web applications

DECLARE @i INT=42

DECLARE @ char(99)=''
WHILE @i>0
SELECT @=left(@i%2,1)+@,@i/=2
SELECT @=replace(@,x+x+x,'?')
FROM(values
('01'),('10'),('001'),('010'),('011')
,('100'),('101'),('110'))s(x)
WHERE not(@ like'%000%'or @ like'%111%')
PRINT~-isnumeric(@)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results