Dear All,
I'm trying to create a regular expression query to match phone numbers
in a database field.
My issue is this , the numbers have no set standard for input in the db.
So the number in the db could be in multiple formats.
EX:
333.333.3333
(333)333-3333
333-333-3333
3333333333
So I am wanting to find matches and ignore any non-numeric values and
need some help with the expression.
The query would be something like:
SELECT tel FROM leads WHERE do_not_call = '1' AND tel REGEXP 'the expression'
The number I am looking for will already have all the non numerics stripped and will
be in the format of nnnnnnnnnn.
Any help would be appreciated.
Thank you,
Paul

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.