Exclude Specific Word From Results

[#1]

I have a table for all project names and the resources names for each project, I want to exclude every resource from the table that contains the word "Vendor" in it's name

[m_woolf]

Load

     *

From TableName

where index(Resource,'Vendor') = 0;

[Anonymous]

Hi Talal,

LOAD

*

WHERE SubStringCount(Upper(Resource),'VENDOR') = 0;

Regards!!

[tamilarasu]

One more solution,

LOAD *

Where WildMatch(Resource,'*Vendor*') =0;

Or

Where Not WildMatch(Resource,'*Vendor*');