On Fri, 28 May 2010 17:19:37 -0700, Jim Terman <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
