> is it possible to get the size of a BLOB and
> use it in a query?
>
> e.g. I wan't to get the biggest BLOB out of
> my table and to know how many bytes it has.

Only with an UDF.

Search for F_BLOBSIZE in the FreeUDFLib.

With regards,

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