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

[markgraham123]

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.

[sunny_talwar]

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

[markgraham123]

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, ' ')

[marcus_sommer]

You mean something like this?

Where

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

- Marcus

[Gysbert_Wassenaar · Accepted solution]

Like this:

Where

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

[markgraham123]

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.

[markgraham123]

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.

[marcus_sommer]

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

[jonathandienst]

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...

[marcus_sommer]

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

- Marcus