David Crayford wrote: > How do I do something similar to DB2 decimal() function which will add > trailing zeros to precision?
You could use the standard SQL CAST() to convert the value back into a number, by why not simply sort by the original number to begin with? ORDER BY max(cpu1) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
