On Fri, 28 May 2010 17:19:37 -0700, Jim Terman <jter...@tivo.com> wrote:
>SELECT rowid FROM phonebook > where last_name = "Smith" > and first_name = "John"; By the way, string literals (text) in SQL should be delimited by single quotes, not double quotes. Double quotes are used to allow reserved words as identifiers (table names, column names and the like). -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
