Good advice all around. The only thing I will add is that you need to make sure trailing blanks are removed on insert from varchar fields as the ANSI PADDING standard keeps trailing blanks in storage and this does also have some affect on other operations.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question