Validation Rule for notification_email_address

[gvee-uk]

notification_email_address is a bit of a weird one.

The value is never sanity checked by SQL Server when used, and it silently truncates it to a maximum of 100 characters, leading to some unwanted side effects such as malformed email address(es)!

Technically speaking this can use a semi-colon delimited list of addresses, so long as the total length is less than 100 characters. However it is more commonly used for a single email address value (hence the name being a singleton).

As a minimum I want it to be validated such that:

• An exception is thrown if the value is longer than 100 characters

Nice to haves:

• Throw an exception if the string is too short
• Throw an exception if the value (or values if semi-colon delimited) don't look like valid email addresses (which might trump the previous rule)

[gvee-uk]

If we move to pydqntic the length check should be easily achievable using constr which has min_length and max_length options.