Just to clarify the OP, the Where Match statement will go in the preceding load statement rather than the SQL Select statement
[FacGroupDefs]: LIB CONNECT TO [pharmoresql production (pharmore_rwinkel)]; LOAD FGID, FGName
WHERE Match(FGName, 'Bria Management','Carr','DAAS Management'); SQL SELECT FGID, FGName FROM "Fac"."dbo"."FacGroupDefs";
But this would require to bring in unnecessary data through SQL which you will remove in the preceding load. So, I think it would be better to restrict in your SQL statement using OR method that Stefan has pointed out or use another similar approach.