Ask a Question related to Microsoft SQL / MS SQL Server, Design and Development.
-
Aaron Bertrand - MVP #1
Re: format number into currency format ($1,000,000.00)
SELECT '$' + CONVERT(VARCHAR, CONVERT(MONEY, 1000000), 1)
"lamP" <phantlam@yahoo.com> wrote in message
news:085901c347da$57a24200$a001280a@phx.gbl...> I need to format a numeric field into currency with comma
> place holder. I can use substring to format it, but it
> cummbersome. Is there a quick and easy way to do it.
>
> Thanks
Aaron Bertrand - MVP Guest
-
format currency
Hello All & Greetings. Can someone pl tell me in a hurry how I can format a currency item in 2 decimal places. thanks in advance. RK -
How do I view currency field in format $xx.xx
Hi everybody, I would like to know how do I view a value that has a currency type (Access) in the format $xx.xx. An example of what I would like to... -
Number Format
Hi, In the FrontPage Database Wizard I have the following custom query: Select *, FORMAT(Number, '#.00') AS fNumber FROM MyFile When I view... -
Format Currency in ASP?
Is there an easy way to format a number into a currency display style eg: $100,000. I have this set in my Access database on the field but my asp... -
Format Textbox on exit to Currency
I am new to ASP/VBScript and I am trying to format a texbox when a user exits it. In Visual Basic you could put the following in the Exit property...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
