September 5, 2002 at 1:21 pm
Hi, I'm new to this discussion group. I have a question. Does anyone know how I might get a numeric value of money data type to display as spelled out numbers?
September 5, 2002 at 2:00 pm
Don't suppose this is what you are talking about:
declare @x money
set @x = 123.45
print cast (@x as decimal(9,2))
-------------------------
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
September 6, 2002 at 3:38 am
Here is a script I wrote a while back to convert money to the word value. Depending on what you need to accomplish you will have to alter to fit your needs but should help provide a start.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply