Rejecting Null records

[chulett]

Just for grins...

The Left() adds nothing, the assignment is unneeded and the values are 'backwards' IMHO. I personally would name the stage variable something like svIsEmpty and the expression would automatically evalute to "true" or "false" where true would indicate it is, in fact, null or empty:

Code: Select all

Trim(NullToEmpty(column))=''

Then your reject constraint would be simply "svIsEmpty".