471,355 Members | 1,621 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,355 software developers and data experts.

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!

Nov 25 '06 #1
2 2159
On 25 Nov 2006 11:13:51 -0800, jf****@gmail.com wrote:

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

-Tom.

>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!
Nov 25 '06 #2
Thanks alot! That worked great!

Tom van Stiphout wrote:
On 25 Nov 2006 11:13:51 -0800, jf****@gmail.com wrote:

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

-Tom.

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!
Nov 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

96 posts views Thread by Karen Hill | last post: by
8 posts views Thread by Thomas A. Anderson | last post: by
2 posts views Thread by Welie | last post: by
6 posts views Thread by Phil Stanton | last post: by
5 posts views Thread by lim4801 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.