[dba-SQLServer] Find the second occurrence of a character in astring

I found a response to a discussion "Parse Full name into first and last
name" that seems to work (bottom of the page).
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=1
16943


HTH
F K Kendrick


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
artful at rogers.com
Sent: Tuesday, December 19, 2006 8:28 PM
To: dba-sqlserver at databaseadvisors.com
Cc: Peter Brawley
Subject: [dba-SQLServer] Find the second occurrence of a character in
astring

Assume these two values in two rows in the table of interest:

Andrei Pascal
Arthur B. Fuller

I need to parse out the surname. I can't just grab the characters following
the first space, unless there is only one space. But if there are two
spaces, then I need the trailing string following the second space.

CHARINDEX( 'f', 'abcdefgh' ) returns 6  so that part is easy. How to find
the second occurrence, if any? In fact, assuming really bizarre data, what I
want is the string following the last space in the value.

Even that may not work, given Portuguese and Spanish and French surnames,
but for now I will live with that.

Suppose an entry such as:

Juan Carlos de la Vega

I need to grab the string following the last space, in T-SQL syntax.

Any ideas?
TIA,
Arthur


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com