Multiple SQL IF statement

Question

So if I got a column like this:

Notes   
A, B, C    
A    
A, C    
A, F

How do i do a multiple if statements that would look through the column and if it has an A print "cash", if it has a B print "Check", if it has a C print "money order". And concatenate them into one string. Or if a case statement would be better?

Answer 1

select 
case when Notes like '%A%' then 'cash' else '' end + 
case when Notes like '%B%' then 'Check' else '' end + 
case when Notes like '%C%' then 'money order' else '' end as 
customstring
from table

Answer 2

select replace(replace(replace(Notes,'A','cash'),'C','money order'),'B','Check')

or you can use Case statement also