Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Load
*
From TableName
where index(Resource,'Vendor') = 0;
Hi Talal,
LOAD
*
WHERE SubStringCount(Upper(Resource),'VENDOR') = 0;
Regards!!
One more solution,
LOAD *
Where WildMatch(Resource,'*Vendor*') =0;
Or
Where Not WildMatch(Resource,'*Vendor*');