11 Replies Latest reply: Jul 15, 2015 4:04 PM by Mark Graham

Using Match/Wild match to select fields from 100-300

Hi,

I'm trying to select only the points which are from 100-300 using Match in where condition.

Where

(Branch='ABC' and Match(Points, ' ')

Can anyone help pls.

• Re: Using Match/Wild match to select fields from 100-300

Not sure I understand Mark, would you be able to elaborate?

• Re: Using Match/Wild match to select fields from 100-300

Hi Sunny,

I wanna select the values from the field "Point".

It should be of the range 100-300 for Branch 'ABC'

So, i'm trying to use the below code. But not able to specify range ....

Where

(Branch='ABC' and Match(Points, ' ')

• Re: Using Match/Wild match to select fields from 100-300

You mean something like this?

Where

Branch='ABC' and Points >= 100 and Points < 300

- Marcus

• Re: Using Match/Wild match to select fields from 100-300

Hi,

I was trying to know is there any way to use Interval match or any other function other than using Greater than and less than symbols.

• Re: Using Match/Wild match to select fields from 100-300

You could use match(Points, 100,101,102, ...) or instead of match a mapping and applymap() or you could use a join-table as filter but what speaks against >= and <=?

- Marcus

• Re: Using Match/Wild match to select fields from 100-300

Thanq Marcus

• Re: Using Match/Wild match to select fields from 100-300

Like this:

Where

(Branch='ABC' and Points >= 100 and Points <= 300)

• Re: Using Match/Wild match to select fields from 100-300

Hi,

I was trying to know is there any way to use Interval match or any other function other than using Greater than and less than symbols.

• Re: Using Match/Wild match to select fields from 100-300

To use Match you would have to list all the possible symbols in the range 100 - 300, so I think the previous suggestions will work better, although you could use

Where WildMatch(Points, '1??', '2??', '3??') as a condition

This will allow things like 1XY as well as numbers...

• Re: Using Match/Wild match to select fields from 100-300

Yea an interessting approach but shouldn't it be: WildMatch(Points, '1??', '2??', '300').

- Marcus

• Re: Using Match/Wild match to select fields from 100-300

Thanq Gysbert