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

Ivan