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