Mark A wrote:
> "Serge Rielau" <srielau@ca.ibm.com> wrote in message
> news:5ihpmqF3p7b65U1@mid.individual.net...
>> Now, now, that would be a cheap shot, like making VARCHAR a synonym for
>> VARCHAR2. I mean - who would do that??? Oh, never mind, ...
>> A measily "2" sure ain't worth a precious bit.
> If you go down that road, you will have to make following idiotic changes:
> columnA = '' (2 single ticks) is the same as columnA is null, and not the
> same as columnA = ' ' (tick, blank, tick).
Hmm, OK, let's - hypothetically - assume DB2 were to make this change,
what behavior would you expect if, say an empty string is LOADed into a
CHAR column? Would that be a NULL or a blank?
Presumably there must also be some functions which treat NULL as empty
string.
E.g. what about TRANSLATE?

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab