<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Can you test for Null...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT> </DIV>
<DIV>Regards<BR>Paul McKenzie<BR>SMSS Ltd.<BR>Wellington<BR>New Zealand</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=johnc@s4-technology.com href="mailto:johnc@s4-technology.com">JC</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=delphi@ns3.123.co.nz
href="mailto:delphi@ns3.123.co.nz">DUG</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, August 20, 2004 12:34
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [DUG] size of a blob</DIV>
<DIV><BR></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>
<P>
<HR>
<P></P>_______________________________________________<BR>Delphi mailing
list<BR><A href="mailto:Delphi@ns3.123.co.nz">Delphi@ns3.123.co.nz</A><BR><A
href="http://ns3.123.co.nz/mailman/listinfo/delphi">http://ns3.123.co.nz/mailman/listinfo/delphi</A><BR></BLOCKQUOTE></BODY></HTML>