RegionCodeFromIP

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

RegionCodeFromIP uses MaxMind for extracting the Region.

Return value datatype

String

Impact of null value

If input is null, returns null.

Feedback and Knowledge Base