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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 using a variable in an ORDER BY clause

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-08 : 11:52:33
Patty writes "Is there any reason why a variable can't be used in an Order By clause? I am setting the variable depending on the Radio Button selected as follows:
ORDER BY :ls_mod
ls_mod is declared as string and I'm moving in "dbo.DHTFOSCH.CREW" which is the table and column.
Thanks."
   

- Advertisement -