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 "%100[%]%"; or select * from mytable where myfield like "%100\%%"; but neither seem to work with sqlite dp _____________________________________________________________ Join the Skunky email revolution at http://www.skunkbox.com The UK's best ISP - ADSL & Dialup http://www.mrwebspace.net Stone Junction - Somebody sign this band ! http://www.stone-junction.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]