This is the way I would do it also. Store the data exactly as the user enters it (or supplies it). Then use either functional indexes if your back-end supports it or add another field that is the canonacalized version (all lower, all upper, stripped of spaces, etc).

-derby