[V4RB] SQL again ... arrrgh!

[Peter Lindgren]

Hej!

valentina-bounces at lists.macserve.net <> skrev Tuesday, October 26, 2004 7:20 PM:

> Tuesday, October 26, 2004, 7:04:24 PM, you wrote:
> Pf> I'm trying to construct a set of canned searched in my current
> Pf> project & while most are working fine I'm stumbling on one pair.
> Pf> They are to find records where one VString field is empty and not
> Pf> empty respectively. As a precaution I've tried to construct my
> Pf> searches to cover both possibilities, that an empty field is an
> Pf> empty string and that an empty field is null.

> You say " the string field is empty" - so I think that NULL
> value is the best description. "Empty string" approach  is
> possible but not so clear.
> I would say that empty string is value with zero length but
> it is DEFINED value - you see?

Would it be possible to prepare the data first before running the query?
First set all empty strings to NULL, then query for IS NULL?
UPDATE table SET column=NULL WHERE column=''

Your application handles NULL as empty strings, right?

/Peter
-- 
Peter Lindgren, dataingenjör FDT System AB
http://www.fdt.se/           0920-24 33 00