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 > 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 > You cannot. At least not yet. See ticket #324. http://www.sqlite.org/cvstrac/tktview?tn=324. As an interim workaround, you could defined your own "like()" function using the sqlite_create_function() API that implemented built-in escapes. Any user-defined function named "like()" is used to implement the LIKE keyword of SQL. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _____________________________________________________________ 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]