Subject Re: [firebird-support] Size of a blob select?
Author Helen Borrie
At 12:46 PM 31/08/2004 +1200, you wrote:
>Hi All,
>I'd like to be able to do a select based on size of a blob field.
>Is it possible to do something like ... select * from mytable where
>myblob.size>1024 ... to select only records where the blob is over 1k?

If your server is on Windoze, you can use the external function F_BLOBSIZE,
which is in FreeUDFLib (download from It takes a column
reference and returns the size in bytes. To paraphrase your example (since
SQL isn't an OO language yet (!):

select * from mytable where