Xuanvinh Vu <[EMAIL PROTECTED]> wrote: > Sorry it was actually quite simple for the WHERE clause it should be > > WHERE Name LIKE '2_%' > > to select Name that starts with the string "2_"
Note that '_' is one of the special characters LIKE operator recognizes: it matches any character (the other one, %, matches any sequence of characters). Thus, the condition you show is actually looking for strings that begin with '2' and are at least two characters long. You want something like this: WHERE Name LIKE '2\_%' ESCAPE '\' Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users