T SQL - Name Format - String manipulation

[Molkas]

Hello everybody,

I'm new to MS T SQL. I'd like to request your help with name formatting. My data comes from one single table and contains employee names like this:

ANDREW J. O'BRIEN JR.
I need to format the names as follows:

O'Brien, Jr. Andrew J

Thank you in advance for your assistance.

Ralph.

 

[SQLBill]

I doubt all of your names are in that format. Can you give us a sample of the different ways names appear?

For example, do they all have a middle initial? Do some have a middle name instead, or no initial?

BTW-this question has been asked/answered a few times on this site. You might try doing a search along with posting the information I requested.

-SQLBill

Posting advice: FAQ481-4875

 

[Molkas]

Thank you for responding so quickly to my post SQLBill. You're absolutely correct. Most of the names in my table actually contain just first name and last name. However there are some names with Jr. and II/III suffixes. The typical data in my table will be:

Andrew O'Brien. I need the data to be formatted: O'Brien, Andrew

Thank you once again for your assistance.
Ralph.

 

[SQLBill]

Check out this THREAD183-1224679.

-SQLBill

Posting advice: FAQ481-4875

 

[Molkas]

Sorry I couldn't reply sooner. Thank you very much for the tip. Ralph