Have you tried casting to numeric or decimal?
--
Bryan Ashcraft (remove brain to reply)
Web Application Developer
Wright Medical Technology, Inc.
------------------------------------------------------------------
Macromedia Certified Dreamweaver Developer
Adobe Community Expert (DW) ::
http://www.adobe.com/communities/experts/
"JohnGree" <webforumsuser@macromedia.com> wrote in
message
news:f2urog$4v0$1@forums.macromedia.com...
> ok found it thanks
>
> but i am getting a weird result
>
> sum(cast(ClientCostPerSMS as INTEGER))as AmountWeCharged
>
> this column has decimals as 0.10 and 0.08 etc nothing
over the amount of
> 1
>
> the result i am getting is 0 but this is not true. how
can i do a sum of a
> decimal?
>
> thanks
>
>