SQL to run mathematical equations

[ColdWaterBlue]

I've heard that I can use SQL to run dynamically changing mathematical equations. I've got the equation stored in a string (i.e. "((100-75)/100)*100") with the values randomly changing. the formula will not stay constant either, but it is the example I am using. How do I get this to produce a result that I can store in another string? Thanks. Nick

[Colin Angus Mackay]

ColdWaterBlue wrote: I've heard that I can use SQL to run dynamically changing mathematical equations. It has the potential. You could create some dynamic SQL and execute it.

EXEC ('insert the dynamic sql between the apostrophes')

The final solution depends on the source of the data (which table(s) in the database, and which columns) and how dynamic you want your forumulas. For instance, you could set up a table to hold the formulas. You are probably looking at writing some stored procedures to do the properly.

---

Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums