On Sun, 29 Nov 2009, Ted Rolle, Jr. wrote: > I need for computed total price to display with leading and trailing > zeros. > E.g. > 1 -> 1.00 > 2.5 -> 2.50 > .9 -> 0.90
Ted, It is most common to handle display issues in the UI component. _Most_ applications have three components: a database back end (SQLite here); some middleware code in the language of your choice for business logic, reporting, etc.; and the UI that allows interaction with the application's user. Presentation of output, and formatting of user input is done with the UI code. Such formatting is not part of SQL. Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
