Perfect!
I will use it.
Thanks.



>>Sure, more details:
>>
>>I have a Fee Setup table in order to know how to calculate Customer fees for a given transaction, based on ranges of transaction amounts, for example:
>>
>>

>>To Country      From $      To  $        Calculate Formula
>>Puerto Rico       1.00        100.00      @yUsaAmt * 0.05
>>Puerto Rico     100.01       1000.00      (@yUsaAmt * 0.05) + @ySpecialChrg
>>

>>And so on for many countries and ranges and other possible variables.
>>
>>During my loop, I am scanning a set of transactions and have to calculate the Fee for every transaction, based on the formula.
>>
>>From my transaction record I will pre-define values for @yUsaAmt and @SpecialChrg, Example:
>>

>>Trans #1        Amount $      Special Charge    Fee Formula $
>>0001              50.00            0.00            2.50
>>0002             150.00            3.00            10.50    ( $7.5 + $3.00)
>>

>>The way to calculate the fee is dynamic, but parameters may be 1 or 2 or 3 or more. I just pre-define a set of possible variables but i don't know how many of them will be used in the formula, so I can't create a specific string to be processed through sp_executesql. In Fox we used to do it with just Evaluate() function.
>>
>>I hope to be clear, and thank you again.
>>
>>
>Hi Juan,
>
>You can build something similar to VFP TEXRMERGE
>

>DECLARE
>	@expr 		varchar(100),
>	@sql 		nvarchar (200),
>	@yUsaAmt 	money,
>	@ySpecialChrg 	money,
>	@yResult 	money;
>	
>SET @expr = '(<<@yUsaAmt>> * 0.05) + <<@ySpecialChrg>>';
>
>SET @yUsaAmt 	  = 150.00;
>SET @ySpecialChrg = 3.00;
>
>SET @expr = REPLACE(@expr, '<<@yUsaAmt>>', CAST(@yUsaAmt AS varchar(20)));
>SET @expr = REPLACE(@expr, '<<@ySpecialChrg>>', CAST(@ySpecialChrg AS varchar(20)));
>
>SET @sql = N'SET @yResult = ' + @expr;
>EXECUTE sp_executesql @sql,
>		N'@yResult money OUTPUT',
>		@yResult OUTPUT;
>
>SELECT @yResult;
>