On Sun, Jun 5, 2011 at 8:47 PM, Igor Tandetnik <[email protected]> wrote:
> iip <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
