Filter formula containing a text

Hi,

I'm trying to create a formula that uses new formulas SORT, UNIQUE and FILTER to count how many unique equipments  of a particular brand have worked in different construction sites. That main problem is that I dont have a column with exactly the brand name. It is written along with it's model name.

In resume, how may I filter something that contains a group of words? And I have tried using "*"__"*"

Here is the formula wich is not working:

=SORT(UNIQUE(FILTER(CRM[[SITE]:[Sub.Class]];(CRM[SITE]="IACANGA")*(CRM[Sub.Class]="HEAVY")*(CRM[Description]=("*"&"JOHN DEERE"&"*"))));2;1;FALSE)

May somebody help me?