How to find multiple items with wildcards in SQL

Hi! I’m pretty new to the SQL stuff – this is what I’m trying to do:

WHERE: Customer Name = “Romanow%” or “BCS%” or “%anse c%”

I know that that’s not the correct way to write it… because I’ve tried a million different ways. Any suggestions? 🙂

Thanks, Tricia 🙂