Re: SQL UPDATE question

On Mar 14, 2008, at 1:30 PM, Joshua wrote:

> Hi,
> Here is a quick and easy one I have a questions about:
>
> I have a table (customers) that has a field (firstname) with the
> following data.
>
> firstname
> --------------------
> Mike H
> Josh
> Jim B
> Katie I
> Jeff
> Suzy
> John R
>
>
> Can someone provide the syntax for a SQL UPDATE statement that will
> remove middle initial in the above column and leave the first name
> intact?

-- notice there is a space before the .* in the regex
UPDATE table
SET firstname = regexp_replace(firstname, ' .*', '');

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com