Colin MacDonald - 2008-11-13

Hi all - for my client, I have a simple table that shows first name, last name, address, city, state, zip, and an ID number. Each has it's own column.

Now, they want to display the first and last names in a single column, but still allow the user to sort by either one. So instead of:

First Name | Last Name | Address | City
John | Smith | 123 Elm | New York

They want:
First Name Last Name | Address | City
John Smith | 123 Elm | New York

And they want to be able to sort either the first OR last name.

Any thoughts?

Thanks!