Data validation

I want to have a data validation rule that defines a pattern (in regular expression if possible) for phone numbers. Only phone numbers that matches this pattern should be possible to insert into the database.

The application that reads and updates this column should be able to work with different database vendors. So the SQL statements for select, update and insert must be identical for different vendors.

Are there any way of doing this (that works with most of the popular databases), without using triggers?

Regards,
Fredrik Received on Tue Jan 13 2004 - 07:23:14 CST