Posted by Madhivanan on 12/27/07 13:31

On Dec 27, 12:30 am, Erich93063 <erich93...@gmail.com> wrote:
> 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

Where do you want to show data?
If you use front end application, use format function there

• Next in forum: Re: SQL2005: Running TSQL commands in single-user mode
• Prev in forum: Re: Database Tripled In Size!!
• Thread view: Re: Format Number on Select

[Reply to this message]