Select on contact field doesn't find results

2003-09-02 Thread Alexander Verkooijen
Hello all, (I've searched the list archive and the server readme's to see if this a known problem but I can't find anything) Does anybody understand why the second select doesn't find the node BLAAT2 ? I must be missing something, but I've been staring at this for quite some time and I can't see

Re: Select on contact field doesn't find results

2003-09-02 Thread Andrew Raibeck
Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Select on contact field doesn't find results Hello all, (I've searched the list archive and the server readme's to see if this a known problem but I can't find anything) Does anybody

Re: Select on contact field doesn't find results

2003-09-02 Thread Alexander Verkooijen
, 2003 5:04 PM Subject: Re: Select on contact field doesn't find results Yes, this is correct SQL behavior. If you examine the COLUMNS table for this column, you will see that the CONTACT field supports null values: tsm: STORMANselect