>
> Anyone know of a way to somehow combine two columns into one
> column in
> the same query that I can order in MSSQL 2000?
>
> What I have is a list of technologies that has an institution
> column in
> it's display. This column displays the companyName column if
> it is not
> null or the ttoOfficeName column if it is not null. If they are both
> null it displays n/a. What I want to be able to do is order that
> institution column by clicking on the heading.
>
> Right now I can't pass in orderBy=companyName or
> orderBy=ttoOfficeName
> because that would put one or the other before the other.
ISNull(ISNull(CompanyName, ttoOfficeName), 'n/a')
If CompanyName is null, then it will take ttoOfficeName
If both are null, then it will give "n/a" as the result for the ORDER BY
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
