RE: [DUG] size of a blob

[JC]

Title: Message

No, 'where image is null' doesn't seem to detect an empty blob!   Any other ideas?     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul McKenzie Sent: Friday, 20 August 2004 1:08 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] size of a blob Can you test for Null...   Regards Paul McKenzie SMSS Ltd. Wellington New Zealand ----- Original Message ----- From: JC To: DUG Sent: Friday, August 20, 2004 12:34 PM Subject: [DUG] size of a blob 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

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