Hello please,
Appreciate your help here.
I have a field string that wants to find if that exists between two range strings on character basis.
Ex:
String lower boundary : "ABD"
String upper boundary : "ALGKP"
field String : "ABE"
Now the field string "ABE" exists between "ABD" and "ALGKP".
Here the comparison is char-by-char. i.e
A is b/w A & A, true
B is b/w B and L, true
E is b/w D and G, true
So finally returns true.
Another example:
For the same above boundaries, if the field string is "ABC", it should return false since C not b/w D & P.
For the same above boundaries, if the field string is "AB", it should return true.
Thanks
Dileep