By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,804 Members | 1,666 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,804 IT Pros & Developers. It's quick & easy.

Query to identify invalid phone numbers

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.