<div>
Try <br />
<br />
Cast (substr(l.details, instr(l.details , ':' ) +1), varchar(5))<br />
<br />
or whatever size you need
</div>


Try

Cast (substr(l.details, instr(l.details , ':' ) +1), varchar(5))

or whatever size you need

<div>
That gave me an error at the ,<br />
<br />
I did cast to a double but it created it as a zero.<br />
<br />
The value I am looking to see is .70
</div>


That gave me an error at the ,

I did cast to a double but it created it as a zero.

The value I am looking to see is .70

<div>
First make sure the extraction gets you the value out.<br />
Can you post the string from which you want the data extracted?
</div>


First make sure the extraction gets you the value out.
Can you post the string from which you want the data extracted?

<div>
<div class="content wysiwyg-content">
I am having to pull a cost from a string....<br />
&nbsp;substr(l.details, instr(l.details , ':' ) +1)AS charge,<br />
<br />
This works for doing the calculations correctly, HOWEVER when I to print the value is prints as an 'object' &nbsp;not a string.<br />
<br />
I have tried cast and convert....how can i get this above code to print the actual string out
</div>
</div>


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

cast mySQL string to double

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.