forgot to cc the list...
# [EMAIL PROTECTED] / 2003-03-18 08:06:37 -0700:
> On Sunday, March 16, 2003, at 03:33 AM, Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2003-03-15 08:29:51 -0700:
> >>On Thursday, March 13, 2003, at 12:46 PM, Roman Neuhauser wrote:
> >>># [EMAIL PROTECTED] / 2003-
# [EMAIL PROTECTED] / 2003-03-13 11:51:52 -0700:
> This is not proper syntax, but I would think it is close...
> select replace(contact_phone, REGEXP "^[1234567890]",'') from
> individual;
I don't use REs in MySQL, but inverse classes are written [^spec],
not ^[spec].
--
If you cc me or
Hello All,
I am trying to develop a SQL statement to ultimately strip a field of
everything buy numeric digits. Does anyone know how to do this or can
anyone look at the below code and give direction if I am on the right
track?
For example, let's say the contact_phone field has 2 records:
(555
Hello All,
I am trying to develop a SQL statement to ultimately strip a field of
everything buy numeric digits. Does anyone know how to do this or can
anyone look at the below code and give direction if I am on the right
track?
For example, let's say the contact_phone field has 2 records:
(555
