Monday, April 23, 2012

Convert string with expression to decimal

I have a table which has a column 'Faktor' (varchar(50)) which contains expressions like:



1/3
2*9/5
0.567
0.23


No, I am searching a way to execute a select like



select Faktor from Artikel


which should return a column of type decimal with the values



0.333333
3.6
0.567
0.23




No comments:

Post a Comment