Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Trigger Question?

Author  Topic 

basek
Starting Member

1 Post

Posted - 2001-10-03 : 13:11:25
Scenerio:
I have a table called ORDERS with a column called ShippingLocation. This column must always hold values in UPPER Case. Sometimes the applications inserting values into the database are inserting in LOWER Case values.

Question:
How would I go about creating a Trigger to check for Case and transform it to UPPER Case if it is not already inserted that way. Is there an easier way to go about this?

Thanks!!
   

- Advertisement -