-
Padding, Rounding, Truncating and Removing Trailing Zeroes
Greg Larsen offers some tips for displaying numeric fields as strings. Included are examples on how to pad zeroes on the left side so that numbers will be the same length, how to pad the left side of a number with spaces so that each number is right justified, how to display a decimal column without any trailing zeroes or decimal point and how to round a decimal number to a specific number of decimal places.
This story continues at http://www.databasejournal.com/featu...le.php/2222111
_______________
Thanks,
Linda
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|