- Tue Oct 25, 2016 3:20 am
#57079
"... I just thought there may be a better way than converting sources variables before comparing to converted target variables..."
I do this:
if lower(response) == "no" then gosub [whyNot]
It seems to be nearly functionally identical to what is being requested. It does require that the "Flag_Variable" in the prior example be all lower case. If you are unsure that this will be the case, just do this:
if lower(response) == lower(Flag_Variable) then gosub [whyNot]
That will work just fine even if it does require two LOWER() functions.
If the intent was to have ANYCASE() resolve any differences between upper and lower case of both the Flag_Variable and the response variable when we don't always know what either might be, then we are out of the realm of a single argument function. We would have to have a function which takes two arguments and compares them OR create a new operator to do it. I would just use two LOWER() functions and be done with it!