Setting the Database Data in UPPER case Only | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Setting the Database Data in UPPER case Only

How can I set the the Database to have data in UPPER Case only.It means the user enter the data in either Mixed Case or Lower case, But the Data must be Inserted into the Database only in UPPER Case. I would like to handled this at the Database end without using UPPER function. raj
The only way I can think of is to use instead of triggers to force the data to upper case when it is inserted/updated other than using stored procedures to update the data from the application, and so inside the proc force the relevant columns to uppercase. There is no setting within the database to force case upper/lower only whether the database is case sensitive or insensitive
Cheers
Twan
]]>