SELECT * FROM 表 WHERE (
CASE LEN(身份证号) WHEN 15 THEN '19'+SUBSTRING(身份证号,7,6)
WHEN 18 THEN SUBSTRING(身份证号,7,8)
ELSE '30001231' END)<CONVERT(CHAR(8),GETDATE(),112)
本文引用通告地址: http://blog.csdn.net/xueguang/services/trackbacks/511859.aspx