Pls Help

[sujasundaran]

Hi
i have a table in which I have a Column Say.(EXPR) of Datatype Varchar() and i store an expression Say, "1 + 3 " as a string in the table, i need to write in a single SQL Query which return 4 (ie Result of evaluation of the Expression...).
Thanks
X

[mikesgt2]

why have you stored an expression?

[Anon]

Save the result in a variable, run $arr=explode(" ",$variable) and check the values in the array to make it do what you want it to do.

[tomhath]

I don't thing SQL has an "eval" function. You could eval it in php after returning the value.