Problem with INSTR()

[John Esak]

Let's agree to disagree. :-)  I only truly agree with you on one point.
Adding the functionality that would allow INSTR() to be case-sensitive
*would* be a really good addition to filePro... and keeping the default
operation to case-insensitive so as not to go against the entire filePro
paradigm ... makes sense and I agree.  On all else, you have not convinced
me at all.  A function whose purpose is to search for specific characters
within a field, should do just that... and if one of the characters to
search for happens to be chr("76"), the function should not stop and return
the position for some other chr(value). It just doesn't make sense to me.
Yes, I love the case-insensitivity of filePro... the whole paradigm...
great, terrific, keep it, don't change it. However, if the program is smart
enough to know the difference for purposes of filenames, etc., it should
also be smart enough to do specific searches... currently the function
INSTR() can only search for *some* characters in the ASCII set it is
using... not all of them. By your definition "search for specific
character(s)" the word specific has NO meaning. If I want the position of
the first "L" and get the position for the first "l", I might as well have
gotten the position for the first "q". Either are equally useless to me.
Again, I fully agree that the default should stay as the rest of filePro,
there are many times I don't care about case... even MOST of the time by a
huge margin. However, that is no reason for crippling this function, so much
so, that you *need* another function just to get this first function to do
its main job. An option switch is needed.

Thanks for the debate. It's a win-win situation as always... that is if you
feel the case-sensitive option for INSTR() is worthwhile. :-)  Otherwise, it
is a you-win...and-i-and-the-rest-of-the-filePro-community-lose situation.
:-(

I hope we didn't bore people too much... :-)

So, should I put in a request for INSTR() to get a case-insensitive switch,
or can you just put it on some internal "todo" list? :-) I stopped using the
wish-list about a year ago because there has never been one iota of feedback
from the company regarding any work done there... so, if you want, I'll just
send it through support@ as usual.

John