Is it possible to use LIKE and IN for a WHERE statment?

Question

I have a list of place names and would like to match them to records in a sql database the problem is the properties have reference numbers after there name. eg. 'Ballymena P-4sdf5g' Is it possible to use IN and LIKE to match records

WHERE dbo.[Places].[Name] IN LIKE('Ballymena%','Banger%')

Answer 1

No, but you can use OR instead:

WHERE (dbo.[Places].[Name] LIKE 'Ballymena%' OR
       dbo.[Places].[Name] LIKE 'Banger%')