check constraint**

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: RM (m_r1824_at_yahoo.co.uk)
Date: 03/07/04 

Date: Sun, 07 Mar 2004 10:41:04 +0430

Hi

Can I refer the range of values in check constraint
  to a table column values instead of constant values like
below?

CONSTRAINT CK_emp_id CHECK (emp_id LIKE
    '[A-Z][A-Z][A-Z][1-9][0-9][0-9][0-9][0-9][FM]' OR
    emp_id LIKE '[A-Z]-[A-Z][1-9][0-9][0-9][0-9][0-9][FM]')

Thanks 

-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/