摘要： select cert_no from jsw_user_info where len(cert_no)<18create function f_CID15to18(@sfz char(18))returns char(18)asbegin declare @osfz varchar(18) declare @i int,@ai int,@wi int,@sum int,@mod int,@result int set @osfz=@sfz set @sum=0 IF len(@osfz)=15 begin set @osfz=substring... 阅读全文