Check constraint with condition

[Sureshy]

Hello All.

I need a constraint against records created/amended that have an invoicenumber beginning with CN%, ensure the analysiscode is not like the value ' %'. As some people are entering spaces in the analysiscode.

Anyway this logic does not work ...

alter table invoicesalesanalys
add constraint check_anaLYSISCODE
check (ANALYSIS1CODE not like ' %' where invoicenumber like 'CN%')

I need a way of tackling it - can anyone help?

Thanks

[slimdave]

I'd think that something like ...

check (NOT (ANALYSIS1CODE like ' %' and invoicenumber like 'CN%'))

... or ...

check (ANALYSIS1CODE not like ' %' or invoicenumber not like 'CN%')

[Sureshy]

Hmm...

Yes the AND logic works correctly.

basically check those 2 conditions are not true.

Thankyou very much.

Suresh