Hi Monica, > WHERE table.code like table2.code+'%' > > really i dont know if i am doing something wrong for sqlite, because > in access my query works very good.
Replace the + with || which is used to concatenate strings. In fact, I think || is the SQL standard. See: http://www.sqlite.org/lang_expr.html Tom BareFeet -- Best prices on ADSL1 & ADSL2 in Australia http://www.tandb.com.au/broadband/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users