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-09-24 : 01:12:07
|
| Jay Allen writes "I have a Employee table set up on SQL Server 7.0 and need to do a search on it. I search on Pay Roll Number, File Number and Name. The table is set up with a Pay Roll Number, File Number, Last Name, First Name and more fields not listed here. I need to return the results as follows. Pay Roll Number, File Number and Employee Name. The Employee Name if made up with the Last Name and the First Name. How do I use an Aliase to concatinate Last Name to First Name([Last Name], [First Name])?" |
|
|
|
|
|
Aliases