0

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

2

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?

|improve this answer|||||
  • Computed column? – Vérace Dec 27 '16 at 19:02
  • No front end environment to handle this, the data is pushed from various resources like excel, notepad, database table copy. So the action must be on database side. – Vignesh Rajendran Dec 28 '16 at 3:27
  • @Vignesh Rajendran - Check out this answer from SQLTeam.com. – SQL_Underworld Dec 28 '16 at 17:27
  • @SQL_Underworld I don't want to use trigger or any statements to achieve the solution, finding options by default a column change the data in UPPER case – Vignesh Rajendran Dec 29 '16 at 9:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.