On mán, 2007-06-25 at 12:44 -0500, Joshua wrote:
> I have a column that looks like this
>
> firstname
> -----------------
> John B
> Mark A
> Jennifer D
>
> Basically I have the first name followed by a middle initial. Is there a
> quick command I can run to strip the middle initial?
how about:
select regexp_replace(firstname,' .*','') as firstname from footable;
or:
select substring(firstname FROM '(.*) ') as firstname from footable;
gnari