您的当前位置:首页正文

身份证号月日加密

2024-12-03 来源:个人技术集锦
SELECT  GJRY.XINGM,GJRY.RENZGW,GJRY.WENHCD,
case  length(GJRY.SHENFZH)   when 18   then   substr(GJRY.SHENFZH,0,10)||'****'|| substr(GJRY.SHENFZH,15,18)
else  substr(GJRY.SHENFZH,0,8)||'****'||substr(GJRY.SHENFZH,13,15)    end   SHENFZH
,GJRY.SHIRZSH,GJRY.SHIRDJZW,GJRY.YINYSLDRY
FROM  GL_QIDQYGJRY GJRY
WHERE  GJRY.GONGSMC like '%南京市板桥汽渡管理处%'
显示全文