Update Queries: Modify Records and Fix Bad Data

摘要

If you're like me, you were excited when you rolled out your first application to make someone else's life easier. You watched them use your application and explained how to navigate it using the cool menus and buttons you created. You walked away fairly comfortable that you made their job easier (and that you have a little more job security). But you may have failed to take something into consideration: the data itself. No matter what you do to control your user, some user will find a way to enter data in a way you didn't intend. Whether they make mistakes and enter a misspelled word a few dozen times, keep the caps lock key on, or just don't follow instructions, you'll eventually have to fix and maintain the data. In this article, I'll show you how to quickly change large sets of data. You'll learn how to change one value to another, eliminate ALL CAPS, and get your data to sort properly— even when it looks like that isn't possible. Queries aren't just for show!