Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Like this:
Where
(Branch='ABC' and Points >= 100 and Points <= 300)
Not sure I understand Mark, would you be able to elaborate?
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, ' ')
You mean something like this?
Where
Branch='ABC' and Points >= 100 and Points < 300
- Marcus
Like this:
Where
(Branch='ABC' and Points >= 100 and Points <= 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.
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.
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
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...
Yea an interessting approach but shouldn't it be: WildMatch(Points, '1??', '2??', '300').
- Marcus