RE: [DUG] size of a blob

[Witherden, Stephen]

Title: Message

In MS SQL server I would probably resort to something like:

 

select name from CONFIG_ITEMS

where len(substring(image, 0, 4)) > 0

 

You will probably have to have a CASE statement for nulls though...

 

Stephen

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of JC
Sent: Friday, 20 August 2004 12:35 p.m.
To: DUG
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