Hello all, The simple question is, is there any way in SQLite to format (left align) integers? So for example I want to print 1 as 00001, 23 as 00023, 102 as 00102, etc.
The real issue I'm trying to solve is a sorting one. I run some SQL which takes some integers and creates a column for sorting with data like following: 1.1.2.3 1.2 1.12.4 It gets sorted as follows, (whereas I want it sorted as above): 1.1.2.3 1.12.4 1.2 Hence if I could left align the printing of the integers it would sort correctly, but if there is another way to get the sorting I want, I could use something else... Thanks! Josh _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
