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 www.cvalde.net). 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
f_blobsize(myblob)>1024

./heLen