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 -- View this message in context: http://old.nabble.com/How-to-sort-within-a-text-field-tp33073347p33073347.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users