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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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?

    thanks
    Sunday, February 14, 2010 9:25 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
Latin1_General_CI_AI);
    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