I'd think that something like ...
Code:
check (NOT (ANALYSIS1CODE like ' %' and invoicenumber like 'CN%'))
... or ...
Code:
check (ANALYSIS1CODE not like ' %' or invoicenumber not like 'CN%')