sorry :( >> version: >> 3.3.4 or 3.x >> >> System test: >> Win2003(NTFS) >> >> Script: >> select * from tResult where tex like '%ra%' >> result = 0 >> >> select tex from tResult where id = 3229 >> tex = "...Oracle..." >> >> Soft on broblem: >> sqlite3explorer, >> and my soft >> >> sample db: >> http://www.aidagw.com/files/dba.zip >>
dhc> Thank you for the excellent information. dhc> Your query works correctly when run in the dhc> sqlite3 shell. Probably this is a bug in dhc> sqlite3explorer. dhc> -- dhc> D. Richard Hipp <[EMAIL PROTECTED]>