求助!字段筛选的疑问

[wing7742]

有数据表如下:
create table tb(num varchar(50))
insert tb
select '0' union all
select '00' union all
select '00' union all
select '0000' union all
select '000000' union all
select '0000000' union all
select '0000000' union all
select '00000000' union all
select '000000000' union all
select '000000000' union all
select '00000000000' union all
select '0000000000000' union all
select '000001901212' union all
select '0044-2222222222' union all
select '0049117666666666' union all
select '0061-412317906' union all
select '0061-47777777' union all
select '0065-98888888' union all
select '0065-99999999' union all
select '013000000000' union all
SELECT '' UNION ALL
SELECT NULL

想获得所有字符为'0'的结果

num
-------
0
00
00
0000
000000
0000000
0000000
00000000
000000000
000000000
00000000000
0000000000000

求正则写法。。。

[快溜]

select * from tb PATINDEX('%[^0]%',num)=0

[快溜]

select * from tb PATINDEX('%[^0]%',num)=0 and num<>''

[gw6328]

[Quote=引用 1 楼 ssp2009 的回复:]
SQL code
select * from tb PATINDEX('%[^0]%',num)=0
[/Quote]
帮顶。

[wing7742]

色狼的patindex给了提示 3Q