Description
Extracts the two character ISO-3166-2 (US or Canada) or FIPS 10-4 code for the state/region from a given IPv4 string (dot-decimal notation).
Syntax
RegionCodeFromIP(ipaddress)
Examples
RegionCodeFromIP('69.59.196.211')
returns 'VA'.
Notes
The function uses GeoLite2 data created by MaxMind, available from http://www.maxmind.com
Return value datatype
String
Impact of null value
If input is null, returns null.