Querying Phone Numbers

When performing a query on a phone number, do not include any format characters such as commas (,), hyphens (-), periods (.), the letter x, or spaces.

You can query for only country 61 by typing +61* but you cannot query for only North American phone numbers this way, because +1* returns all phone numbers. To query for North American phone numbers, type the following: not like +1*.

When you use a phone number in a query, the country code of the default locale is automatically added to the query, unless the default locale is North America. If the default locale is North America, then no code is added. For example, if the default locale is Germany, and the user types 0181 in the phone field of a query, then the German country code (+49) is added to the query. The query becomes +490181*.

To find a number for a country other than the default country, the user must specify the country code in the query. To avoid limiting the query to one country, the user must refine the query, and remove the country code portion of the query specification.

To see a demonstration of this behavior, look at the Contacts screen. Every phone number for a country other than the default contains +n at the beginning, while every phone number for the default country code appears as local (without a plus sign). Phone numbers that have the +n require explicit queries. The user must specify the country code and the number. Local numbers are returned normally.

The following table provides examples of how to query phone numbers.