List:General Discussion« Previous MessageNext Message »
From:Scott Klarenbach Date:November 28 2005 6:58pm
Subject:How to use Logic in View Statment?
View as plain text  
I'd like to do the following in my view

select
  fieldOne,
  fieldTwo,
  if(fieldThree.length>0) then fieldThree as Company
  else fieldFour as Company

from table;

I realize this syntax isn't correct and length doesn't exists, but is
this possible?  I've seen it done in SQLServer, but can't remember the
syntax.
Thread
How to use Logic in View Statment?Scott Klarenbach28 Nov
  • Re: How to use Logic in View Statment?SGreen28 Nov
    • Re: How to use Logic in View Statment?Cory @ SkyVantage28 Nov
      • Re: How to use Logic in View Statment?SGreen28 Nov
    • Re: How to use Logic in View Statment?Martijn Tonies28 Nov
    • Re: How to use Logic in View Statment?Scott Klarenbach5 Dec
      • Re: How to use Logic in View Statment?SGreen5 Dec
  • Re: How to use Logic in View Statment?Peter Brawley28 Nov
RE: How to use Logic in View Statment?Gelu Gogancea28 Nov