Consider the following table definition:
CREATE TABLE large_images (id INTEGER ,image BLOB);
The following statement casts the BLOB column to a VARBYTE type, and uses the result as an argument to the POSITION function:
SELECT POSITION('FFF1'xb IN (CAST(image AS VARBYTE(64000)))) FROM large_images WHERE id = 5;