retrieving a string into mathematical expression

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 456,564 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,567 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 1062 | Replies: 2

•

Join Date: Oct 2007

Posts: 1

Reputation: clear1140 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

clear1140

Offline

Newbie Poster

retrieving a string into mathematical expression

Oct 25th, 2007

Is it somehow possible to retrieve a string and then convert it into a mathematical expression? for example i have this string '14200 * 5' and then i want to convert this into a mathematical formula so that i could get the result of it which is 71000.. .. i thought eval() function was available on MSSQL , is there such a function on MSSQL?

Thanks....

•

Join Date: Aug 2007

Location: KSA

Posts: 147

Reputation: kb.net is an unknown quantity at this point

Rep Power: 2

Solved Threads: 26

kb.net

Offline

Junior Poster

Re: retrieving a string into mathematical expression

Nov 1st, 2007

Hi,

You have to use the EXEC function but after some conc. ex:

EXEC('select ' + '14200 * 5')
you may need to use stored procedures.

It is never about the number of languages you know, you either have the logic of programming or you don't ...

Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.