How to make column data in upper case by default in SQL Server 2008?
You could use a trigger to accomplish this but why not deal with this in the front-end of the application? Or, if you're displaying the data somewhere else (such as a report), set the case there? 

Why do you want the data stored in a particular case?