|
|
Posted by Knowledgy on 01/09/08 20:16
cast( '5.0000' as decimal(9,2))
--
Sincerely,
John K
Knowledgy Consulting, LLC
knowledgy.org
Atlanta's Business Intelligence and Data Warehouse Experts
"Erich93063" <erich93063@gmail.com> wrote in message
news:5c976abd-e0a0-4f5d-8f02-ac697a516f75@t1g2000pra.googlegroups.com...
>I have a price field that when I query it, it returns the price as
> "5.0000". What function can I use to return the price as "5.00"?
>
> THANKS
Navigation:
[Reply to this message]
|