How to use wildcard search in SQL?

Select query with %

Select * from Customer where [Name] like 'Phi%'

- Search for customer that starts with 'Phi'