Hi Juan,

There's nothing in SQL Server like VFP EVALUATE(). Your alternative is to run dynamic t-sql code using EXECUTE() or sp_executesql.


>Thank you, but not so easy, maybe I didn't explain well.
>
>The expression will come from a character field, it isn't known in advance.
>
>Assume you read the formula like this:
>

>Declare @Expr  varchar(100)
>Set @Expr = Select cFormula from FeeSetup where .........
>

>
>@Expr will contain a text like '@var1 + @var2' and if those variables are pre-defined then I want to obtain the evaluation of the expression.
>