cast mySQL string to double
Posted on 2013-12-13
I am having to pull a cost from a string....
substr(l.details, instr(l.details , ':' ) +1)AS charge,
This works for doing the calculations correctly, HOWEVER when I to print the value is prints as an 'object' not a string.
I have tried cast and convert....how can i get this above code to print the actual string out