Meaning of '&' in a wildmatch

[Applicable88]

Hello,

I would like know, when the wildmatch function looks like this what is does with the search:

IF(WildMatch([Ordernumber]&[Materialnumber],'6*MMFF*','3KKLL*'), 1,0) AS [Packaging]

Someone wrote like this in Load Editor. I only know to wildmatch ONE filed. What does that & do with the whole search?

Thank you very much.

Best. 

[MikeA · Accepted solution]

As far as I know it just works by combining the two fields then checking against the strings.

So if Ordernumber = 1 and Materialnumber = 22 it'd be "WildMatch(122,'6*MMFF*','3KKLL*')"

Wildmatch is simply a native if this equals that and can be used the same way with combining multiple fields and variables.

[Applicable88]

Thanks @MikeA !