On Sun, Jun 5, 2011 at 8:47 PM, Igor Tandetnik <itandet...@mvps.org> wrote:
> iip <iip.umar.ri...@gmail.com> wrote: > > As subject, I want to know how search column that contain ascii chr(0) > > select * from MyTable where hex(MyField) like '%00%'; > > -- > Igor Tandetnik > yes, I already did that, so there are no other way that more efficient than this one right? because I'm still have to add separator to avoid wrong catch just like '100D' -> '10-0D'. Thank a lot, -iip- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users