Posted: Thu Feb 03, 2011 8:31 am
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:
Then your reject constraint would be simply "svIsEmpty".
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))=''