Like Operator for checking multiple words

Question

I'm struggling for a like operator which works for below example

Words could be

MS004 -- GTER   
MS006 -- ATLT   
MS009 -- STRR   
MS014 -- GTEE   
MS015 -- ATLT

What would be the like operator in Sql Server for pulling data which will contain words like ms004 and ATLT or any other combination like above.

I tried using multiple like for example

where column like '%ms004 | atl%' 

but it didn't work.

EDIT

Result should be combination of both words only.

Answer 1

Seems you are looking for this.

`where column like '%ms004%' or column like '%atl%'`

or this

`where column like '%ms004%atl%'