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