I found that the data in the table that I am querying is not standard. The phone number fields are text fields and have phone numbers in several different formats: [xxx-xxx-xxxx] or [xxx/xxx-xxxx] or [xxx xxx xxxx] or [(xxx)xxx-xxxx]. My client cannot standardize the data and wants me to write a query that will ignore non-numeric characters. I will be looking to match a phone number in xxxxxxxxxx format. How can i structure the where clause to ignore anything non-numeric?