You're right, % is standard. MS Access used * and more recently supports both * and %. I'm not aware of any other DB that supports using * as wildcard for LIKE.
It's in the docs, but is kinda buried in the middle of this page: http://sqlite.org/lang_expr.html Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building Flex based products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: Jonas Sandman [mailto:[EMAIL PROTECTED] Sent: Thursday, January 24, 2008 7:28 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] startswith and contains Oh I have no idea. I thought LIKE with '%' was a standard, % being the wildcard. /Jonas On Jan 24, 2008 1:25 PM, Pavel Kosina <[EMAIL PROTECTED]> wrote: > I was still trying "*jup*" .... > Could you show me documentation page, where this is mentioned? > > Pavel Kosina > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------