EXTRACT()

Scalar. Returns a subset of the bytes from a BLOB value.

Syntax

EXTRACT( blob, start, count )

Parameters
blob	The BLOB from which to extract bytes.
start	The starting byte (one-based) to extract from blob.
count	The number of bytes to extract.

Data Types
Return	blob	start	count
BLOB	BLOB	Integer	Integer

The following example returns the BLOB without its first character:

INSERT INTO OutStream
SELECT Extract(A.BlobObject, 2, Length(A.BlobObject)-1)
FROM A;