>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.

remove the 's

DECLARE @expr char(15)
Declare @var1 char(5)
Declare @var2 char(10)

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

set @expr = @var1 + @var2

PRINT @expr