> with this query. What the alternative of Evaluate() in TSQL?
>
> SELECT
> 09/01/2004 + 'CAST(......)' AS myDateTime
>
> FROM myTest
You can use sp_executesql, EXECUTE, or EXEC, depending on which version of
SQL Server you're using. You should try to avoid this when possible, though,
as it's usually inefficient.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
