On Wed, 2007-08-29 at 18:37 +0800, RaghavendraK 70574 wrote: > Hi, > > Am using sqlite 3.4.0 > > stmt= sqlite_prepareV2("select * from test where '?' like t || '%' order by > t desc);
You need to remove the ' quotes around the question mark. At the moment the expression is a literal string value, not an sql variable. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------