On 27 May 2004 at 14:17, Pierre Y. wrote:

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

Talking about syntax, why not just CAST(MyBlob AS BLOB SUB_TYPE 1)?

SY, Dimitry Sibiryakov.