Re: Data validation

fredrik_bertilsson_at_passagen.se (Fredrik Bertilsson) wrote:
>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

A phone number is really three atomic attributes, the NPA, NXX, and Station Number. There are a finite set of all of these attributes. Would domain tables not do the trick? Received on Tue Jan 13 2004 - 07:39:33 CST