Re: How to use Logic in View Statment?

[Peter Brawley]

Scott

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

SELECT
  fieldOne,
  fieldTwo,
  IF( LENGTH( fieldthree ) > 0, fieldthree, fieldFour ) AS Company
FROM table;

PB

-----

Scott Klarenbach wrote:

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.

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.8/184 - Release Date: 11/27/2005


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]