[DUG] size of a blob

[JC]

Title: Message

Hi all,

 

Is there any way of getting a query result where the size of a blob field ('image' in this case) is larger then 0?

 

Thus something like:

 

select name
from CONFIG_ITEMS
where size(image) >0

 

 

 

TIA,

John

_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi