Where statement with Match, not match, and not Wildmatch

[markgraham123]

Hi Everyone,

I'm trying on the Where statement below: But getting an error ") Expected"

(Name='ABC' and Match(Department,'B') and  not WildMatch(Region, B*, C*, D*, F*, H*, J*, L*, M*, O*, P*, Q*, R*) and not Match(Region, SBB, STS, UPU, PSI))

fetch the details of ABC, where department is B.

Donot include the regions starting with B, C, D, F, H, J, L, M, O, P, Q, R.

Donot include the regions SBB, STS, UPU, PSI.

Please lemme know whether i'm on the right track.

Help pls.

[hic · Accepted solution]

You need to put B* in single quotes. (And all other strings you want to compare with.)

HIC

[sunny_talwar]

This is what Henric‌ means

Where (Name='ABC' and Match(Department, 'B') and not WildMatch(Region, 'B*', 'C*', 'D*', 'F*', 'H*', 'J*', 'L*', 'M*', 'O*', 'P*', 'Q*', 'R*') and not Match(Region, 'SBB', 'STS', 'UPU', 'PSI'))

[markgraham123]

Thanq Henric.:)

[markgraham123]

Thanq Sunny.

Happy that You're back.