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

Home -> Community -> Usenet -> c.d.o.tools -> Re: IF statement fails when it should no (PL/SQL)

Re: IF statement fails when it should no (PL/SQL)

From: Guenter Szolderits <g.szolderits_at_gmx.at>
Date: Sat, 17 Mar 2001 00:03:41 +0100
Message-ID: <3ab29bfb$0$25062@SSP1NO25.highway.telekom.at> 






"don" <chambers_at_inquiregroup.com> wrote:



> I have the folowing if statement:

> IF (theDoc.SDNumber<>'') THEN




The empty string ('') is interpreted as NULL, so what you really want is:



if theDoc.SDNumber is not null then


...


end if;



Günter
Received on Fri Mar 16 2001 - 17:03:41 CST












Original text of this message













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