[sqlite] Apostrophe's and Quotes

[Grant Robinson]

I've been googling for a solution to this and haven't been able to find 
one.  Here is my problem:

I have a table named questions that looks like this:
id|question|answer
1|Cat''s name|fluffy
2|Dog''s name|buffy
When I execute the following query:

select * from questions where question = 'Cat''s name';

I get no results.  However, when I execute the query
with double quotes:
select * from questions where question = "Cat''s name";

I get 1 row returned.  Can someone explain this discrepancy to me?

Thanks,
Grant Robinson
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]