Example: Explicit Conversion of BLOB to VARBYTE

Teradata Vantageā„¢ Data Types and Literals

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

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;