Format CASE in sp

[brutus6294]

I'm trying to edit a stored procedure..
I want to add the clause that if doc_type=I or doc_type=C
to perform the below Case statement, but am having problems with an acceptable format... Below is the existing statement. How do I add "or doc_type=C"

case when doc_type = 'I' then sum(amt_1) else 0 end as inv_amount,



Thanks

 

[gmmastros]

case when doc_type = 'I' [!]Or doc_type = 'c' [/!]then sum(amt_1) else 0 end as inv_amount,

Or...

case when [!]doc_type In('I','C')[/!] then sum(amt_1) else 0 end as inv_amount,

-George

"the screen with the little boxes in the window." - Moron