Developing.ru

HI ALL

If I have a value of type VARCHAR Ex. '3+(5-2)/3' How can I evaluate this to get value of type INTEGER 4 ?

Thanks

I think, you should write your own string parser

I think your main task is to parse expression on constants, operations and functions. Because of operations have an evaluation priority you can present them as tree nodes. Then you start evaluate from the most distant node up to root.
Also the easiest way is to use already done functions from imported dll's, you'll easy get it from web.