<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY>
<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></BODY></HTML>