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