Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Where condition

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

1 Solution

Accepted Solutions
sunny_talwar

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.

View solution in original post

3 Replies
sunny_talwar

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
Creator III
Creator III

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