Re: regexp problem
REPLACE takes three arguments,
1) the string to operate in
2) the string that is searched for
3) the string to replace it with.
youre second argument is not a string, it's a regular expression matching operation. It will return either TRUE or FALSE of phone matches your regular expression.
BTW, you use * in the REGEXP, as far as I can see, this matches everything, always!
Anyway, that's why it does not work. As for a solution to get it working, I can't think of anything better than to REPLACE each character a to z individually. Which seems rather clumsy, I know. I'm still thinking of a better way...I hope there is one...
Subject
Views
Written By
Posted
2930
August 03, 2005 03:04AM
Re: regexp problem
2000
August 03, 2005 07:21AM
2097
August 03, 2005 08:32AM
2640
August 03, 2005 09:08AM
Sorry, you can't reply to this topic. It has been closed.
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.