小问题，有条件的读取数据

[北京不不]

一个数据库里有个字段txt
txt
1.2.33333
1.2.14
1.2.344
1.2.5
1.2.3.4
1.2.3.5
1.2.3.4.1
1.2.333.4
1.2.3333.444444
我要取类似于1.2.*当于我只取三个数字的类似1.2.的
如。。
1.2.33333
1.2.14
1.2.344
1.2.5
我不想取
1.2.3.4
1.2.3.5
1.2.3.4.1
1.2.333.4
1.2.3333.444444
SQL语句该怎么写。

[子陌红尘]

ACCESS里的实现方法：
select * from 表 where txt like '1.2.*' and right(txt,len(txt)-4) not like '*.*'

[子陌红尘]

select * from 表 where txt like '1.2.%' and len(txt)=len(replace(txt,'.',''))+2

[lw1a2]

create table #t(txt varchar(30))
go

insert into #t values('1.2.33333')
insert into #t values('1.2.14')
insert into #t values('1.2.344')
insert into #t values('1.2.5')
insert into #t values('1.2.3.4')
insert into #t values('1.2.3.5')
insert into #t values('1.2.3.4.1')
insert into #t values('1.2.333.4')
insert into #t values('1.2.3333.444444')
go

select *
from #t
where txt like '1.2.%' and txt not like '1.2.%.%'