Where condition

[smilingjohn]

HI All,

Iam trying to use Where condition , by using * but this is giving an error when reloading ..

can some one please correct my script ..

Resident TableA

where match(Code,'18.6*','18.7*','18.8*',18.9*,18.10*',18.11*');

Thanks in advance

[sunny_talwar · Accepted solution]

I think you are missing few single quote

Resident TableA

Where WildMatch(Code, '18.6*', '18.7*', '18.8*', '18.9*, '18.10*', '18.11*');

Making a change to my response based on Pooja's response below.

[pooja_prabhu_n]

Hi,

Try wildmatch instead of Match

where WildMatch(Code,'18.6*','18.7*','18.8*','18.9*','18.10*','18.11*')

Thanks,

Pooja

[sunny_talwar]

That's true too