> Xuanvinh Vu <[EMAIL PROTECTED]> wrote: >> I have search google but have not found a solution. I have a field >> called Name and I want to select the rows that have Name starts with >> certain string. How could I do this? > > select * from tableName where Name LIKE 'xyz%'; > > Igor Tandetnik
I would add that it seems from Xuanvinh's post that he is looking for names that start with '2_'. Since LIKE considers '_' to be a metacharacter that matches any single character, wouldn't the '_' need to be escaped? Something like this: select * from tableName where Name LIKE '2/_%' ESCAPE '/'; - Richard Klein _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users