Hwo do i make the column values UPPERCASE from the Designer? RRS feed

  • Question

  • Hi friend,

    in my table i have several columns that needs to be set to uppercase i could use an insert statement but i need to set the coumn to upper at design time so how do hat with SME express?

    Sunday, February 14, 2010 9:25 AM


  • Hi,

    I would suggest that you create a check constraint on the column, thereby enforcing only upper case values as acceptable for input.

    ALTER TABLE dbo.myTable
    ADD CONSTRAINT Uppercase CHECK (ColumnData= UPPER(ColumnData) COLLATE
    Hope this helps.

    John Sansom | Blog: www.johnsansom.com | SQL Server DBA at Expedia, consultant with Santech Solutions
    • Proposed as answer by Kalman Toth Sunday, February 14, 2010 10:14 AM
    • Marked as answer by code_warrior Sunday, February 14, 2010 11:38 AM
    Sunday, February 14, 2010 9:40 AM