Query to identify invalid phone numbers

Hey everyone,

Sorry if this is a stupid question, but I can't find the answer.

I need to query a list of phone numbers where the format is ##########
and have the results show any rows that the phone number starts with 0
or 1.

Any help would be greatly appreciated!

On 25 Nov 2006 11:13:51 -0800, jfshaw@gmail.com wrote:

For the WHERE clause use:
Left$([PhoneNumber],1) in ('0', '1')

-Tom.

Quote:

>Hey everyone,
>
>Sorry if this is a stupid question, but I can't find the answer.
>
>I need to query a list of phone numbers where the format is ##########
>and have the results show any rows that the phone number starts with 0
>or 1.
>
>Any help would be greatly appreciated!

Thanks alot! That worked great!

Tom van Stiphout wrote:

Quote:

On 25 Nov 2006 11:13:51 -0800, jfshaw@gmail.com wrote:
>
For the WHERE clause use:
Left$([PhoneNumber],1) in ('0', '1')
>
-Tom.
>
>

Quote:

Hey everyone,

Sorry if this is a stupid question, but I can't find the answer.

I need to query a list of phone numbers where the format is ##########
and have the results show any rows that the phone number starts with 0
or 1.

Any help would be greatly appreciated!

Query to identify invalid phone numbers

re: Query to identify invalid phone numbers

re: Query to identify invalid phone numbers

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about