I have as the followings... create table t ([a] varchar(3), [b] varchar(3));
insert into t(a, b) values('6', '2'); insert into t(a, b) values('5', '3'); insert into t(a, b) values('2', '3'); create table t2([x] varchar(9)); insert into t2(x) select (a || ', ' || b) from t; but I want t2.x sorted as '2, 6' , '3, 5', '2, 3' instead of '6, 2', '5, 3', '2, 3'. Please, help. Thank's. -- View this message in context: http://old.nabble.com/sort-a-contenated-value-as-inserting-tp32550882p32550882.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