Skip to Content
0
Former Member
Jan 09, 2008 at 07:42 PM

Need formula help - query on characters in a text field

19 Views

Post Author: bemmerich

CA Forum: General Feedback

In the database, phone numbers are stored as text, not numbers. Example 123-456-7890

How do I query so that I choose only phone numbers in the format where the 4th character is a dash ➖ and the 8th character is a dash?

This will exclude foreign phone numbers, which is my goal.

Thank you!