Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-06 : 14:48:30
|
Eric writes "Hi,
First, thanks for the forum. It's answered many of my questions.
Now to the problem. I have an employee database that contains both a FirstName and NickName field. My problem comes when I try to create our company phone list. I want to be able to order by FirstName, but for people with nicknames, I want to be able to order by Nickname, alphabetically merged into the FirstName ordering.
Here's an example:
Nickname FirstName
Jim
John
Bill William
The records should be ordered like:
Bill
Jim
John
Any assistance would be greatly appreciated.
Regards,
Eric" |
|
|
|
|
|
ordering records by two fields in the same table