Subject Re: [firebird-support] Size of a blob select?
Author Ivan Prenosil
> 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?

Use UDF to get blob size,
or store its size in separate column (then it can be indexed).