Evaluate the expression stored in varchar column

Teradata Applications
New Member

Evaluate the expression stored in varchar column

Hi,

I have a varchar column with data   10+(0.5 * 10) . Is there a way to evaluate the expression an arrive to a solution = 15 using SQL.

1 REPLY
Senior Supporter

Re: Evaluate the expression stored in varchar column

Doesn't seem to work with plain SQL.

Easiest should be a SCRIPT Table Operator (which would do the eval of the string)...