From: boston103@hotmail.com   
      
   Hello,   
      
   DECODE(loandate, null, 'N', 'Y')   
      
   ..or   
      
   case when loandate is null then 'N' else 'Y'  end   
      
   Rgds.   
      
      
   "bon"  wrote in message   
   news:c7986eaf.0312091002.51327b57@posting.google.com...   
   > I have a mssql view I am translating to oracle syntax   
   >   
   > One of the lines in the mssql view is like this:   
   > DATO=CASE (isnull(loandate,1)) WHEN 1 THEN 'N' ELSE 'Y' END   
   >   
   > In other words, the view will return a Y if loandate has a value, N if   
   > it does not have a value   
   >   
   > How can I accomplish the same with Oracle9?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)