How to do formaula calculation inside a string in SQL Server

• Ramji Sridharan

  SSC Enthusiast

  Points: 187

  More actions

  February 14, 2013 at 2:58 am

  #274136

  HI,

  I need to evaluate a formula in sql server (eg)

  ((a+b)*c)/d, where this formula will be stored inside a string value like

  DECLARE @strFormula VARCHAR(250)

  SET @strFormula = ((a+b)*c)/d

  And now a, b, c and d all will have some values like 15.25, 20, 22.50, 25 respectively.

  pls help me with how to evaluate this

  @mnyFinalOutput = the result of the executed formula (i.e) @strFormula with a,b,c,d values replaced.