> > 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.

True.

Would an update/insert be something like this then?

UPDATE...

SET MyBlob = FILTER(:BlobParam FROM SUB_TYPE 0)

> So it could be :
>
> SELECT FILTER(MyBlob TO SUB_TYPE 1) FROM MyTable...

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com