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]

Reply via email to