> SELECT FILTER(MyBlobColumn, -2, 1)
> etc...

2 details :

1) It would be nice to be consistent with SUBSTRING syntax
2) Blobs already have a sub_type defined a declaration time. So "-2" is not
required.

So it could be :

SELECT FILTER(MyBlob TO SUB_TYPE 1) FROM MyTable...