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)
 order by variable

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-25 : 08:53:12
Ben writes "I asked this question last Friday and either it didn't get posted or it hasn't gotten posted yet.

How do I order by a variable that has the same value as one of the field names.

E.G. I wanted to order by ID, but instead used a variable called varid and it stored the field name value ID? Could I use this variable in the order by statement and have it sort by varid?

Any help would really be appreciated. Thanks."
   

- Advertisement -