Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Expression Evaluation

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-09 : 09:19:17
Yosi writes "Hi,
We are using MS SQL Server 2000. I would like to evaulate mathematical expressions in a user defined function. For example I have a string which contains an expression like '10*(4/8)'. I want to evaluate this expression and convert it to a variable of type numeric, which is 5 in this case.
I know that I can do this by writing an Extended Store Procedure using MS Visual C++, but we don't have any C++ developers in our company. (We use Visual Basic instead)

Thank you"
   

- Advertisement -