Re: [sqlite] escaping " and % in sql statements

thanks, that worked like a charm. tim --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: Dunnigan Pierce wrote: > hi, sorry if this has been asked before or is hidden somewhere in the > documentation. couldn't find an archive of this list to search through and >

[sqlite] escaping " and % in sql statements

hi, sorry if this has been asked before or is hidden somewhere in the documentation. couldn't find an archive of this list to search through and couldn't find it in the docs. how do you escape " and % in sqlite? in other dbs you can do something like: select * from mytable where myfield like