RSS 2.0 | Atom 1.0 | CDF

Search

Categories

 
 
 
 
 
 
 
 
 

Archive

January, 2012 (2)
December, 2011 (1)
October, 2011 (1)
January, 2011 (1)
September, 2010 (1)
June, 2010 (2)
May, 2010 (1)
September, 2009 (1)
April, 2009 (1)
March, 2009 (1)
February, 2009 (2)
January, 2009 (1)
December, 2008 (2)
October, 2008 (2)
September, 2008 (1)
August, 2008 (1)
July, 2008 (1)
May, 2008 (2)
April, 2008 (2)
March, 2008 (2)
January, 2008 (4)
December, 2007 (1)
November, 2007 (4)
October, 2007 (3)
September, 2007 (3)
August, 2007 (3)
July, 2007 (5)
June, 2007 (1)
May, 2007 (5)
April, 2007 (4)
March, 2007 (3)
February, 2007 (4)
January, 2007 (3)
December, 2006 (1)
November, 2006 (1)
October, 2006 (3)
September, 2006 (3)
August, 2006 (6)
July, 2006 (2)
April, 2006 (2)
March, 2006 (2)
February, 2006 (4)
January, 2006 (9)
December, 2005 (10)
November, 2005 (3)
October, 2005 (1)
September, 2005 (4)
August, 2005 (6)
June, 2005 (2)
May, 2005 (3)
April, 2005 (3)
March, 2005 (5)
February, 2005 (2)
January, 2005 (3)
December, 2004 (3)
November, 2004 (5)
October, 2004 (3)
September, 2004 (3)
July, 2004 (5)
June, 2004 (3)
May, 2004 (2)
April, 2004 (3)
March, 2004 (7)

Blogroll

Sign In

# Friday, April 13, 2007
SQL: Display full name in "Surname, Firstname" format.
Friday, April 13, 2007 2:13:30 PM (GMT Daylight Time, UTC+01:00) ( Database )
not the most elegant solution you'll ever see, but i find it very useful when i don't want to store several columns for the different parts of a person's name in a database table.
it takes the surname based on the last space in the name.  so "Paddy Joe Gonzales" will be listed as "Gonzales, Paddy Joe".
Right(FullName, PatIndex('% %', Reverse(FullName))) + ', ' + Left(FullName, Len(FullName) - PatIndex('% %', Reverse(FullName)))   

Comments [0] | | # 
Name
E-mail
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):
Live Comment Preview