How do I… Reject alpha characters in a SQL Server character column?
Posted February 1st, 2008 by Andrew PopoffEnforcing 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. It’s serious business and there are no shortcuts — mistakes, even innocent ones, are just too easy to make. It’s just too easy to enter one too many zeros or enter “6heodore” instead of “Theodore.” Granted, you can’t stop every single mistake at the input stage, but it’s the best place to start. (We are working with SQL Server Express because it’s free and easy to use, but the concept and examples are valid in SQL Server.)
Read more
Tags: SQL |
Category: SQL
Leave a Reply