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
 Transact-SQL (2000)
 SQL eval() equivalent?

Author  Topic 

uberbloke
Yak Posting Veteran

67 Posts

Posted - 2002-10-08 : 06:25:32
I think the answer is no as I can't find it.... BUT....

Is there a direct SQL equivalent of the VBscript and JavaScript eval() function?

I know that you can do the old dynamic sql trick, but I want to eval() some text string statements as part of an order by (and, yes, I have already been looking at the dynamic order by stuff here using CASE :-) without having to put all of the statements in dynamic sql.

It will save me a load of "if"'ing about if anyone has any suggestions....



Andraax
Aged Yak Warrior

790 Posts

Posted - 2002-10-08 : 06:29:17
I think you'll have to do it the hard way :(

/Andraax

Go to Top of Page
   

- Advertisement -