Change sql statement depending on value

Hi,

I have an sql query looking like this:

SELECT cm.ClubMemberID, cm.subscriptionTypeID FROM dbo.ClubMember AS cm

Select allOpen in new window

Now I would like to expand the query by adding a WHERE clause. But I would like to alter the where clause depending of the subscriptionTypeID. So, for example, if subscriptionTypeID = 1 then the query would look like this:

SELECT cm.ClubMemberID, cm.subscriptionTypeID FROM dbo.ClubMember AS cm
WHERE cm.Stopdate > '2018-01-01'

Select allOpen in new window

and if subscriptionTypeID = 2 then

SELECT cm.ClubMemberID, cm.subscriptionTypeID FROM dbo.ClubMember AS cm
WHERE cm.Stopdate < '2018-01-01'

Select allOpen in new window

How can I achieve this scenario?

Thanks for help!

Peter