So I would structure it like this
IF @category = 0
BEGIN
SELECT * FROM Articles WHERE Category = @category
END
EDIT:
You could also use a case statement as so:
select * from Articles where category = (
CASE WHEN @category= 0 THEN @category END)