EVAL() counterpart in T-SQL

[JackR]

Greetings all,

In VB - the EVAL() function can evaluate a literal string within an expression...

How would I do that in T-SQL..? Here's what I'm trying to do: I am updating a variable name that changes...initially @PSt=Phase1Start, then @PSt=Phase2Start, then @PSt=Phase3Start...and so on. Subsequently, we SELECT using @PSt which isn't working at all....??

How can I effect changes to literals then EVAL them at execution...??

Thanks

 

[rac2]

Use exec("a TSQL string&quot. exec() has two or three uses in T-SQL. One use is to interpret a string as a T-SQL statement and execute it. See Books Online.
Here is an example -

DECLARE @whichTableThisTime sysname
DECLARE @PSt VARCHAR(20)

SELECT @whichTableThisTime = 'BobsTable'
SELECT @PSt = '07/01/2002'

EXEC("SELECT * FROM " + @whichTableThisTime + " WHERE taskDate > '" + @PSt + "'")

 

[JackR]

Great - Thank you for your time..!!