Home Forums SQL Server 7,2000 T-SQL CASE Statement in Check constraint? RE: CASE Statement in Check constraint?

  • March 29, 2004 at 2:05 pm

    #500941

    Try this

    ALTER TABLE roysched

    ADD CONSTRAINT CK_title_id

    CHECK (CASE royalty WHEN 10 THEN 'BU2075' ELSE title_id  END = title_id  )


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons