From: Martijn Tonies
Date: November 28 2005 7:49pm
Subject: Re: How to use Logic in View Statment?
List-Archive: http://lists.mysql.com/mysql/192277
Message-Id: <0b8c01c5f454$db3263b0$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit



> I have a similar question.   How do you test if the field in question
> isn't NULL or ''  (empty string)?   Is the LENGTH a good test or is
> there a better way?

WHERE myfield IS NOT NULL

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com