On Fri, 2005-07-01 at 14:51 -0500, Dan Wellisch wrote:
> zipCodeValue =
> wxString::Format(wxT("%s%s%s%s"),"'",zipCodeValue.c_str(), "%","'");
>
> rc = sqlite3_bind_text (rowdata,2, zipCodeValue.c_str(),
> zipCodeValue.Len(), SQLITE_STATIC);
> Do not put quotes around strings that are bound. Just insert them directly. You are trying to LIKE against '''6008%''', not '6008%' as you intend. -- D. Richard Hipp <[EMAIL PROTECTED]>

