String Comparison 1

[dmears1]

I need to search a table for certain area codes. Because the office does not have a uniform way of entering phone numbers into the database, some are entered as (555)555-5555 and others as 555-555-5555.
I have a select statement in which I want to return phone numbers beginning with a certain area code indepent of how the phone number was entered.
I've tried the following:

SELECT customers_telephone FROM customers WHERE customers_groups_id = 3 AND customers_telephone
like '(310)%' OR customers_telephone
like '310%'

but it does not work. If I remove the OR and search for only phone numbers with () or without()the SQL works.

Any ideas on how I can implement this would be greatly appreciated.

http://www.Morter.com

 

[hoinz]

consider precedence of operators AND and OR

 

[dmears1]

Thanks for the reply.
I know that the AND operator has a higher precendence than OR. The example above was the best way I could think of explaining what I want to achieve.

http://www.Morter.com

 

[aardvark92]

How about this?

SELECT customers_telephone FROM customers WHERE customers_groups_id = 3 AND (customers_telephone
like '(310)%' OR customers_telephone
like '310%')

 

[dmears1]

Thanks Aardvark...I didn't realize you could use () in SQL statements.

http://www.Morter.com