How To Use Regular Expressions for Data Validation and Cleanup
You need to provide data validation at the server level for complex strings like phone numbers, email addresses, etc. You may also need to do data cleanup / standardization before moving it from source to target. Although SQL Server provides a fair number of string functions, the code developed with these built-in functions can become complex and hard to maintain or reuse.
The Future of SQL Server Monitoring "Being web-based, SQL Monitor 2.0 enables you to check on your servers
from almost any location" Jonathan Allen.Try SQL Monitor now.