Need multiple Condition in Where Clause

Hi Latheesh,

Thanks, but in my scenario i need to display record with category='Class' even if its 0 but not 'Control'

i changed this like below

elect * From LedgerTable Where (@suppressZero =1 and (Debit + Credit >0) or Category='Class') OR (@suppressZero=0)

anyway thanks again