Subject | Re: Test for NULL in Blob |
---|---|
Author | Ryan Nilsson-Harding <nilsson@bigpond.ne |
Post date | 2003-02-18T02:34:20Z |
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
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