The decimals are fine, i am trying to eliminate the parenthesis, and commas.<br><br>thanks for the start though, i will look into output format.<br><br>Josh<br><br><div><span class="gmail_quote">On 1/19/07, <b class="gmail_sendername">
Chris Hughes</b> <<a href="mailto:christopher.hughes@gmail.com">christopher.hughes@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Is it a decimal field type?<br>If it is make sure that its represented as such.<br><br>OR<br><br>In your select do<br>select field1, field2, format(field3,2) as field3 from whereever<br>If that isn't suitable use the round function instead.
<br><br>-C<br><br>On 1/19/07, Joshua Gauthier <<a href="mailto:jjgauthi@gmail.com">jjgauthi@gmail.com</a>> wrote:<br>> Greetings everyone,<br>><br>> I have a quck question, I am running a query out of mysql and dumping it to
<br>> txt, but I am experiencing some formatting issues, I would prefer my query<br>> to just dump a raw number instead of something similar to this:<br>><br>> ((54948.899902343997,),)<br>><br>> any sage advice you can give would be greatly appreciated.
<br>><br>> Thanks<br>><br>> Josh<br>><br>> _______________________________________________<br>> socal-piggies mailing list<br>> <a href="mailto:socal-piggies@lists.idyll.org">socal-piggies@lists.idyll.org
</a><br>> <a href="http://lists.idyll.org/listinfo/socal-piggies">http://lists.idyll.org/listinfo/socal-piggies</a><br>><br>><br>><br><br>_______________________________________________<br>socal-piggies mailing list
<br><a href="mailto:socal-piggies@lists.idyll.org">socal-piggies@lists.idyll.org</a><br><a href="http://lists.idyll.org/listinfo/socal-piggies">http://lists.idyll.org/listinfo/socal-piggies</a><br></blockquote></div><br>