Hvordan bruges wildcard i forbindelse med kolonnenavn

Jeg mener *-erne skal med under sitationstegnene:

UPDATE WL INNER JOIN FILEMAKER ON Filemaker.Antalmodtaget = Wl.[already delivered] SET WL.[Received YES/NO] = 'Yes'
WHERE ( Wl.Material LIKE "*Filemaker.partnummer*"  AND Wl.[UB/LS] LIKE "*Filemaker.ub*" );

Jeg fik selv løst det med nedenstående, men smid et svar

UPDATE WL INNER JOIN FILEMAKER ON Filemaker.Antalmodtaget = Wl.[already delivered] SET WL.[Received YES/NO] = 'Yes'
WHERE ( Wl.Material LIKE "*"& [Filemaker].[partnummer]& "*"  AND Wl.[UB/LS] LIKE "*" & [Filemaker]![ub] & "*") OR ( Wl.Substitute LIKE "*" &[Filemaker].[partnummer] & "*" AND Wl.[UB/LS] LIKE "*" & [Filemaker].[ub] & "*");

OK :0)