Example: Explicit Conversion of BLOB to VARBYTE - Teradata Vantage

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;