Format integer strings (Function & SP) description
Formats a string representing a numeric or decimal value, to an input length of 6000 characters, and adds commas after every set of three numbers, on all values to the right of the decimal (if any) basically it takes a sting such as '1234567890.123' and returns '1,234,567,890.123'. Nice for a more "human-readable" display of large numbers, money values, etc. Can be utilized as either a function (SQL 2000) or a stored procedure, or cut out into your own script. Tested on SQL 2000 & 7, although it might work on 6.5 as well. CONVERT works well, I know, but this is more flexible, besides, I hate "black boxes", and would rather code it myself anyway :)
File List:
@PSC_ReadMe_346_5.txt
1Kb
fnc_FormatIntegerString.sql
2Kb
sp_FormatIntegerString.sql
2Kb
Similar code
Dollars And Cents To English
(Popularity: ) : This PL/SQL stored function returns the English language translation of the dollars and cents input. (Range: -999999999999999.99 through 999999999999999.99).
Code Library
) : This PL/SQL stored function returns the English language translation of the dollars and cents input. (Range: -999999999999999.99 through 999999999999999.99).