I have BLOBs in my schema and the data will often start with bytes of 0 value.
I'm having a tough time coming up with the proper SQL syntax to select all the columns that start with 2 0's (or any zeros). I have tried: SELECT * FROM mytable WHERE myblob LIKE 0%; SELECT * FROM mytable WHERE myblob LIKE X'0%'; SELECT * FROM mytable WHERE myblob LIKE X'0'%; and a few other combinations that use double quotes. Is there a LIKE syntax that will work with BLOBs in this way? Thank you very much. Shane
