On 03/01/12 17:15, guiz wrote:
Hi all, if I have a table like CREATE TABLE [a] ( [ID] INTEGER NOT NULL, [prdtype] VARCHAR(35) NOT NULL ) and data already inserted as insert into a (ID, prdtype) values (1, '15'); insert into a (ID, prdtype) values (2, '15|10|27|3'); insert into a (ID, prdtype) values (3, '8|6|22'); and I'd like to update table 'a' to achieve sorted result in prdtype as ID prdtype 1 15 2 3|10|15|27 3 6|8|22 given that each sub-prdtype may be represented as only single or double digit and separated by '|' character also each prdtype may have up to 8 sub prdtype, i.e. '2|21|27|28|33|40|43|55' I really appreciate your help on this if you could. Thank's. Rick
a small Tcl script perhaps? then, for each record, it'd be simply a split, lsort, join sequence.
jr. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users