RegionNameFromIP

Description

Extracts the region, state (e.g. USA, Germany) or province (Canada) from a given IPv4 string (dot-decimal notation).

Syntax

RegionNameFromIP(ipaddress)

Examples

RegionNameFromIP('69.59.196.211') returns 'Virginia'.

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.

Feedback and Knowledge Base