|
|
Posted by onedaywhen on 11/13/06 13:19
On Nov 12, 8:48 am, "Tony Rogerson" <tonyroger...@sqlserverfaq.com>
wrote:
> Are you going to finally admit you are wrong and that the only reasonable
> way to validate an email address in a CHECK CONSTRAINT is CLR?
Tony,
Please clarify which aspects of an email address you consider cannot be
validated via TSQL.
I know the things that can be validated using basic pattern matching
(number of characters, exactly one 'commercial at', at least one period
following the 'commercial app', etc) so what do you have in mind that
can only be done via CLR? I assume we can agree that verification (e.g.
can I send mail to this email address) is out of scope.
TIA,
Jamie.
--
Navigation:
[Reply to this message]
|