Synear_API/sql/sql_20180517...

declare  @Caller NVARCHAR(50)
set @Caller='03714567894'

declare @areacode nvarchar(50)--区号

if LEN(@Caller)=11 and @Caller LIKE '[1][3456789]%'
begin
	--处理主叫号码 获取手机号码前7位
		declare @first char(5)
		declare @Top7 char(10)
		
		set @first=LEFT(@Caller, 1);
		if @first='0'
		begin
			set @Top7=SubString(@Caller, 2,7);
		end
		else
		begin
			set @Top7=SubString(@Caller, 1,7);
		end
		--根据前7位获取区号
		select @areacode=F_ZipCode FROM T_Sys_MobileData where F_MobileNum=@Top7
		
end
else
begin
		declare @three char(5)
		declare @four char(5)
		declare @cc int
		
		set @three=LEFT(@Caller, 3);
		set @four=LEFT(@Caller, 4);
		
		--根据区号获取地区ID
		select @cc=COUNT(1) FROM tel_location where tel=@four
		
		if @cc>0
		begin
			set @areacode=@four
		end
		else
		begin
			set @areacode= @three
		end
end
select @areacode