I have a field called contactname, which looks like this
Code:
Al Davis
Bob Smith
Robert Smith
John Anderson
Jake Anderson
What I would like to do is somehow order it by the lastname.
Anyone know how I can do this, i have been using substring and charindex, etc...but haven't been able to figure out how to order this field by the last name.