通过身份证分析出生年月日、性别、年龄的SQL语句

 update [表名] set [性别]=(case when (left(right([身份证],2),1) % 2 = 0) then '女' else '男' end ) where len([身份证])=18 and left(right([身份证],2),1)<>'X'  update [表名] set [性别]=(case when (left(right([身