Oracle, SQL Server and Other Databases
Storing NULL/blank values in SQL files
We encountered an issue when using APPX SQL files, moving from version 4.0.9 to 4.2.6 of APPX. In 4.0.9, empty fields without data were blank. In 4.2.6, these fields are NULL. This is causing problems with other applications that access the shared SQL tables, whose logic is checking for IS NULL. Is there a way to have blank fields retain a value of blank, rather than be NULL in SQL Files?
No, currently there is no way to control that behavior.