Tenkawa a écrit :
Query 1 (correct behavior) sqlite> select id,nick,last from nicks where nick = 'Nick'; sqlite> Query 2 (incorrect?) sqlite> select id,nick,last from nicks where nick = "Nick"; 4|Her|99 5|Her|99 6|Her|99 7|Him|99 8|You|99
When dealing with STRING values, use only single quotes. in your second case, it will consider Column(nick)=Column(Nick) which are obviously the same :) HTH, -- Guillaume MAISON - [EMAIL PROTECTED] 83, Cours Victor Hugo 47000 AGEN Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50 e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com