Sorry, you can also create a view: Create MyView as SELECT Col1 || Col2 aliasname FROM ELEMENT ORDER BY aliasname
Then You can: Select Aliasname from MyView order by Aliasname -----Original Message----- From: Jesse Quijano [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 3:13 PM To: ActiveServerPages Subject: OT: SQL Help Needed First disclaimer: The database structure comes from a VERY well known document/imaging company - I didn't make the mess, I'm just trying to work with it. :) I have a table that contains two fields with the same type of data (Reference Number), but one was used for older documents, and one was used for newer documents. I want to sort on and display the two fields as one (only one will be populated for any given record). I talked to my local Oracle guru here at work and he's given me a syntax like so: SELECT Col1 || Col2 aliasname FROM ELEMENT ORDER BY aliasname It seems perfect, however I'm using a SQL Server, and it's not having any part of that syntax. Does anyone know of a similar way to accomplish this task in SQL Server 2000? Any help is appreciated! Thanks, Jesse http://www.qbstech.com/mycode --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
