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 PROTECTED]
