身份证号码是否有非15或非18位的？
身份证号码是否有不是15位，也不是18位的？ 问题点数：30、回复次数：5Top
1 楼Dennis618（明月照沟渠）回复于 2003-11-04 10:56:29 得分 0
如果有，那出生日期怎么取？Top
2 楼Rotaxe（程序员）回复于 2003-11-04 11:00:54 得分 5
没有
Top
3 楼wzh1215（懒猫）回复于 2003-11-04 11:01:40 得分 5
没听说过！Top
4 楼Leftie（左手,为人民币服务）回复于 2003-11-04 11:02:01 得分 0
不知军管证是几位的Top
5 楼pengdali（）回复于 2003-11-04 11:06:48 得分 20
应该没有。用这个找出：
select xm,xb,sfzhm,gzdw
from Qyyzcryb
where (len(sfzhm)<>15 and len(sfzhm)<>18) or
(len(sfzhm)=15 and (
(substring(sfzhm,9,2)>12)
or (substring(sfzhm,11,2)>31)
or ((substring(sfzhm,10,1) in (1,3,5,7,8) or substring(sfzhm,9,2) in (10,12)) and substring(sfzhm,11,2)>31)
or ((substring(sfzhm,10,1) in (2,4,6,9) or substring(sfzhm,9,2)=11) and substring(sfzhm,11,2)>30)
or (substring(sfzhm,9,2)=02
and substring(sfzhm,11,2)>29))
)
)or
(lent(sfzhm)=18 and (
substring(sfzhm,7,2)<>'19 '
or (substring(sfzhm,11,2)>12)
or ((substring(sfzhm,12,1) in (1,3,5,7,8) or substring(sfzhm,11,2) in (10,12)) and substring(sfzhm,13,2)>31)
or ((substring(sfzhm,12,1) in (2,4,6,9) or substring(sfzhm,11,2)=11) and substring(sfzhm,13,2)>30)
or (substring(sfzhm,12,1)=2 and substring (sfzhm,13,2)>29)
)
)Top
