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

Stuart McLachlan stuart at lexacorp.com.pg
Tue Dec 19 21:06:16 CST 2006


How about (aircode):
RIGHT(FullName,CHARINDEX(' ',REVERSE(FullName))-1)


On 19 Dec 2006 at 18:27, artful at rogers.com wrote:

> 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
> 

-- 
Stuart





More information about the dba-SQLServer mailing list