Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: where clause on null string

Re: where clause on null string

From: <davide_at_yahoo.com>
Date: 13 Nov 2001 12:45:26 GMT
Message-ID: <9sr4l6$14pu82$2@ID-18487.news.dfncis.de> 





Zorglub <no_at_mail> wrote:


> why a WHERE myVarCharCol='data' OR myVarCharCol=''




If the contents of the field is NULL, you should check for 'is null',
not an empty string. And are you sure that the field is not padded with
spaces ?



What happen if you ask



where myVarCharCol like 'data%' ?



Davide
Received on Tue Nov 13 2001 - 06:45:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US