如何根据身份证，获取此人所在的省份

Question

如何根据身份证，获取此人所在的省份

Answer 1

create function f_getcityfromcid (@cid varchar(18))   
returns varchar(50)   
as  
begin    
  
    declare @acity varchar(1000)   
    set @acity = '____,____,____,____,____,____,____,____,____,____,____,北京__,天津__,河北__,山西__,内蒙古_,____,____,____,____,____,辽宁__,吉林__,黑龙江_,____,____,____,____,____,____,____,上海__,江苏__,浙江__,安微__,福建__,江西__,山东__,____,____,____,河南__,湖北__,湖南__,广东__,广西__,海南__,____,____,____,重庆__,四川__,贵州__,云南__,西藏__,____,____,____,____,____,____,陕西__,甘肃__,青海__,宁夏__,新疆__,____,____,____,____,____,台湾__,____,____,____,____,____,____,____,____,____,香港__,澳门__,____,____,____,____,____,____,____,____,国外__,'  
  
  
    set @cid = upper(@cid)   
  
    IF (len(@cid) <> 18 OR patindex('%[^0-9X]%',@cid) > 0)   
        RETURN '你小子骗我，这不是合法的身份证'  
  
    IF substring(@acity,cast(left(@cid,2) as int)* 5+1,4) = ''    
        RETURN '你小子骗我，这身份证的地区码不存在'  
  
  
    RETURN '这小子是：'+replace(substring(@acity,cast(left(@cid,2) as int)* 5+1,4),'_','')   
  
end   
go   
  
select dbo.f_getcityfromcid('341202198702101738')   
drop function f_getcityfromcid   

Answer 2

http://topic.csdn.net/u/20100531/16/22bcaad5-5f77-44be-be0f-7aa0b8d721c0.html

Answer 3

function getInfo(id){
    var arr=[null,null,null,null,null,null,null,null,null,null,null,"北京","天津","河北","山西","内蒙古"
             ,null,null,null,null,null,"辽宁","吉林","黑龙江",null,null,null,null,null,null,null,"上海"
             ,"江苏","浙江","安微","福建","江西","山东",null,null,null,"河南","湖北","湖南","广东","广西","海南"
             ,null,null,null,"重庆","四川","贵州","云南","西藏",null,null,null,null,null,null,"陕西","甘肃"
             ,"青海","宁夏","新疆",null,null,null,null,null,"台湾",null,null,null,null,null,null,null,null
             ,null,"香港","澳门",null,null,null,null,null,null,null,null,"国外"];
    id=checkId(id);
    if (isNaN(id)) return "错误的身份证号码"    ;
    var id=String(id);
    var prov=arr[id.slice(0,2)];
    return prov;
}本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/gisfarmer/archive/2009/01/20/3839701.aspx