[sqlite] SQL question, probably stuipid but ...

I can't remember how to escape a ' in a string. My statement looks something like: insert . values ('DAY'S AVE' .); It's been a long day. Thanks in advance. J. R. J. R. Westmoreland E-mail: j...@jrw.org ___

Re: [sqlite] SQL question, probably stuipid but ...

To escape ' use cosecutive ' , i.e '' On Wed, 18 Feb 2009 10:32:28 +0530, J. R. Westmoreland j...@jrw.org wrote: I can't remember how to escape a ' in a string. My statement looks something like: insert . values ('DAY'S AVE' .); It's been a long day. Thanks in advance. J. R.