The problem that the SQL required to search for nulls should use the IS NULL operator while the SQL required to search for non-null should use the equlaity operator (=). Tersus automatically chooses the correct SQL syntax when you use Find, but when you specify the SQL yourself (in Advanced Find, Database Query or Database Update), you need to take care of this complexity
If Find is not good enough for your needs, the solution is to build the SQL condition dynamically, and use Field=${Value} or Field IS NULL depending on whether you're looking for a "real" value or for a null value.
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign