SQL UPDATE question

From: Joshua <joshua(at)joshuaneil(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: SQL UPDATE question
Date: 2008-03-14 18:30:02
Message-ID: 47DAC42A.5000900@joshuaneil.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Please let me know.

Thanks,
Josh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2008-03-14 18:41:55 Re: SQL UPDATE question
Previous Message Justin 2008-03-14 18:27:58 Re: pgbench not setting scale size correctly?