How to make column data in upper case by default in SQL Server 2008? Normally in SQL, select and insert statements use UPPER() and LOWER() functions to format the column cases. But in this application, whenever new data is inserted it must be stored as UPPER CASE by default.

Example:

insert --> INSERT 
Apollo --> APOLLO 
TyUiOP --> TYUIOP
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?