You can't test BLOBS for having ''.. it's the same as not being able to test
blob string comparisons. You can check for NUL or you can use a UDF
where F_BLOBLEFT(notes,10) =''
but a straight comparison will not work
Alan

-----Original Message-----
From: Ryan Nilsson-Harding <nilsson@...>
[mailto:nilsson@...]
Sent: Tuesday, 18 February 2003 1:34 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: Test for NULL in Blob


Also,

The opposite of my last mentioned query:
SELECT STK_ID, COMMENTS
FROM STOCK
WHERE COMMENTS = ''
(ie looking for all blank comment fields)

Returns ALL records, including the ones which have text in the
COMMENTS field!!

Agghhhhh, I know the err is on my side, but I just can't figure it
out.
It should not be this difficult!!
And I even had a good nights sleep last night!!

hmmmm,
-Ryan



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/