On 6/5/2011 8:47 AM, Igor Tandetnik 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%';

That query doesn't work. If the field contains 0\n, that would match (300A)

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to