<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=040224100-20082004><FONT face=Arial color=#0000ff size=2>In MS
SQL server I would probably resort to something like:</FONT></SPAN></DIV>
<DIV><SPAN class=040224100-20082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=040224100-20082004><FONT face=Arial color=#0000ff size=2>select
name from CONFIG_ITEMS</FONT></SPAN></DIV>
<DIV><SPAN class=040224100-20082004><FONT face=Arial color=#0000ff size=2>where
len(substring(image, 0, 4)) > 0</FONT></SPAN></DIV>
<DIV><SPAN class=040224100-20082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=040224100-20082004><FONT face=Arial color=#0000ff size=2>You
will probably have to have a CASE statement for nulls
though...</FONT></SPAN></DIV>
<DIV><SPAN class=040224100-20082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=040224100-20082004><FONT face=Arial color=#0000ff
size=2>Stephen</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> delphi-bounces@ns3.123.co.nz
[mailto:delphi-bounces@ns3.123.co.nz]<B>On Behalf Of </B>JC<BR><B>Sent:</B>
Friday, 20 August 2004 12:35 p.m.<BR><B>To:</B> DUG<BR><B>Subject:</B> [DUG]
size of a blob<BR><BR></FONT></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial size=2>Hi
all,</FONT></SPAN></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial size=2>Is there any way
of getting a query result where the size of a blob field ('image' in this
case) is larger then 0?</FONT></SPAN></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial size=2>Thus something
like:</FONT></SPAN></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial size=2>select
name<BR>from CONFIG_ITEMS<BR>where size(image) >0</FONT></SPAN></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2>TIA,</FONT></SPAN></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2>John</FONT></SPAN></DIV></BLOCKQUOTE></BODY></HTML>