On 9/16/2013 4:55 PM, karinos57 wrote:
>> SELECT
>> Volume, REPLACE(Volume,'.','')
>> FROM MyTable
>>
> The data in my table looks like this:
>
> 88.97
> 448.58 and etc
>
> i want to show like this with out the period:
>
> 8897
> 44858
>
> I have tried to use different ways but still getting the error i hope
> someone out there can help me. How can i achieve this? thanks
still getting _the_ error? what error is that? can we assume your
table field is a numeric rather than a string value?
you could use to_char(volume*100, 'FM9999999'), or maybe even just
(volume*100)::integer
--
john r pierce 37N 122W
somewhere on the middle of the left coast