Hi All, I have a table like this:
h t0info ( h is primary key, t0info is unique) --------------- 1 /a/d/u 2 /a/e/u 3 /a/f/u 4 /a/g/v 5 /a/b/c/d/e/f input is : /a output should be: d, e f, g and b I am doing this way: select t0info from t0 where t0info like '/a%'; processing on string operations on result set to get d, e, f, g and b. any alternative solution for this? Thanks in advance, Durga. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users