> One column in my table contains email addresses - I want to check
> that any value entered contains a '@'. How do I create a
> CONSTRAINT or CHECK to ensure this when creating the table?
create table em (
em text constraint is_email check (em like '%(at)%(dot)%')
);
will work fine, assuming that this check (something @ something . something)
is acceptable in your context as "looks like an email address"
- J.
Joel BURTON | joel(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant