community.borland.com

Article #25339: What is the equivalent of the GDML 'MISSING' keyword in SQL?

Problem:
When converting from GDML to SQL, don't know what's 
equivalent of 'MISSING' (without the quotes).


Solution:
IB V4.x
IB V5.x

The 'Missing' keyword in GDML is equivalent to 'Null' in 
SQL.  Use "is Null" or "is Not Null" to do comparison.  Don't 
use "=NULL" or "Null" or "<>Null".

Last Modified: 17-OCT-00