Hey all

I have a DB that has FULLNAME as a column...possible data could be as
follows...

FULLNAME
FirstName LastName
FirstName MiddleName LastName
FirstName NickName LastName
FirstName MiddleInital LastName

Now, I have a user that needs to see this sorted by last name so he can
x-ref a report he was given...

I have played with a few things; however, I am having difficulty finding the
last name so I can re-sort...Any help would be greatly appreciated.

Cory Ellingson

Production Services

MS Sql Server LazyDBA home page