Skip to content

Construct a point

Query the province where a phone number is registered. You must specify a phone number in the numeric format in the function. A string passed to the function can be converted by using the try_cast function.

SQL
* |
select
  mobile_province(17600001234)

SQLSample query result:

样例图片