How to use Logic in View Statment?

[Scott Klarenbach]

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.

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