Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: CASE statement in WHERE clause

    Or:

    SELECT col1,col2,col3 from table p WHERE P.HOSPITAL = @HOSPITAL and p.finclass= case when @finclass = 1 then @FinclassCategory else finclass end

Viewing post 1 (of 1 total)