How do I... Reject alpha characters in a SQL Server character column?
Source: Susan Harkins
Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analysis and reports. It only takes one piece of bad data to throw everything off. Susan Sales Harkins explains how to use CHECK constraints in SQL Server to control user input.
This download is also available as an entry in the TechRepublic How do I... blog.