Hello,

I am preparing some dynamic procedures in SQL 2005 but I haven't been able to do something like this (similar to the fox function EVALUATE) :

-- Assume this T-SQL code

Declare @var1 char(5)
Declare @var2 char(10)

set @var1 = 'ABCDE'
set @var2 = '0123456789'

set @expr = '@var1 + @var2'

How could I evaluate the expression @Expr in order to print the value 'ABCDE0123456789' and not the formula ???

Thanks.