Home Forums Article Discussions Article Discussions by Author Discuss content posted by Oscar D Garcia Map IP Address to a Geographical Location RE: Map IP Address to a Geographical Location
SwePeso
SSC-Dedicated
Points: 39752
More actions
July 25, 2009 at 2:49 am
#1030125
No need to cast either
alter function dbo.ConvertIp2Num(@ip varchar(15))
returns bigint
as
begin
return16777216.0 * parsename(@ip, 4)
+ 65536 * parsename(@ip, 3)
+ 256 * parsename(@ip, 2)
+ 1 * parsename(@ip, 1)
end
N 56°04'39.16"E 12°55'05.25"