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