Problem Note 10604: IS BLANK and IS NOT BLANK does not differentiate between nulls and
spaces
If you have a field on your SAS Campaign Management database that is
populated with either null, a space or a blank, the IS BLANK and IS NOT
BLANK operators within selection rules cannot differentiate between
them.
A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html
This hotfix introduces two new ISMCONFIG options: EnableIsEmpty and
EnableIsNull. It also adds the following new operators: IS EMPTY,
IS NOT EMPTY, IS NULL, IS NOT NULL. If you wish to use the new
operators, you must set the EnableIsEmpty and/or EnableIsNull
configuration options to 'Yes' using the SAS Campaign Management Admin
utility.
Operating System and Release Information
| SAS System | SAS Campaign Management | Microsoft Windows NT Workstation | 7.4 | | | |
| Microsoft Windows XP Professional | 7.4 | | | |
| Microsoft Windows 2000 Professional | 7.4 | | | |
| Microsoft Windows 2000 Advanced Server | 7.4 | | | |
| Microsoft Windows 2000 Server | 7.4 | | | |
| Microsoft Windows 2000 Datacenter Server | 7.4 | | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2003-11-13 10:42:18 |
| Date Created: | 2003-08-07 11:12:24 |
