筛选数据解决思路

筛选数据
select Called_Station_Id,F_User_point,h323_connect_Time from TB_CDR where Calling_Station_Id='0429990001' 
and Called_Station_Id like '0[1-9]%' 
and len(substring(Called_Station_Id,charindex('99',Called_Station_Id)+2,len(Called_Station_Id)))>4
and convert (varchar(10),convert(dateTime, h323_connect_Time),112) like '200803%' 
这条语句能够把大多数的＂区号＋９９０００１＂这样的号码找到，但是遇到像＂０２９或０４２９＂等等这样的区号里有９的就不能够筛选出去了　，请教下怎么把这样的数据筛选掉呢？谢谢了

Called_Station_Id这个字段下的有些数据不需要，需要筛选出来．具体的数据是： 
Called_Station_Id F_User_point h323_connect_Time 

0411990002 0.04 2008/03/21 10:15:57 
042913842922224 0.54 2008/03/20 09:46:55 
042913898935335 0.09 2008/03/20 09:27:22 
04293991150 0.09 2008/03/20 08:25:21 
0411990001 0.04 2008/03/17 17:14:52 
0429990002 0.04 2008/03/17 14:14:54 
029990004 0.15 2008/03/15 12:15:56 
我们是要把像0411990001,0429990002,029990004这样的数据筛选掉，保留其他的数据．应该怎么写？

[解决办法]
上次发了的吧？
这个东西很难完全匹配。。
试试

SQL code

declare @t table(Called_Station_Id varchar(20),F_User_point numeric(8,2),h323_connect_Time datetime)  insert into @t select '0411990002','0.04','2008/03/21 10:15:57' insert into @t select '042913842922224','0.54','2008/03/20 09:46:55'insert into @t select '042913898935335','0.09','2008/03/20 09:27:22'insert into @t select '04293991150','0.09','2008/03/20 08:25:21'insert into @t select '0411990001','0.04','2008/03/17 17:14:52'insert into @t select '0429990002','0.04','2008/03/17 14:14:54'insert into @t select '029990004','0.15','2008/03/15 12:15:56'select * from @t where patindex('[0-9][0-9][0-9]99[0-9][0-9][0-9][0-9]',Called_Station_Id)>0orpatindex('[0-9][0-9][0-9][0-9]99[0-9][0-9][0-9][0-9]',Called_Station_Id)>0
[解决办法]
SQL code
--try:select Called_Station_Id,F_User_point,h323_connect_Time from TB_CDR where Calling_Station_Id='0429990001'   and Called_Station_Id like '0[1-9]%'   and patindex('[0-9][0-9][0-9]99[0-9][0-9][0-9][0-9]',Called_Station_Id)!>0and patindex('[0-9][0-9][0-9][0-9]99[0-9][0-9][0-9][0-9]',Called_Station_Id)!>0and convert (varchar(10),convert(dateTime, h323_connect_Time),112) like '200803%'