Query to find all zeroes in table

create table #t
        ( A int, B nvarchar(100));

insert #t
values 
        ( 1, '0000' ) ,
        ( 2, '000' ) ,
        ( 3, '000000' ) ,
        ( 4, '000011000' ) ,
        ( 5, '0000000sh6820090' ) ;

select * 
from #t
where B like '%000%'

---

T-SQL Articles

T-SQL e-book by TechNet Wiki Community

T-SQL blog