Business Analytics Connect, learn and share with over 10000 users across the IBM Business Analytics. Ask a question
When using the INSTR function, the comparison is typically case-sensitive unless you use the 4th argument and set the flag to 1.Not sure that this has been documented and when my luck will run out with this.Microsoft MDX documentation for argument 4 says:
Compare(optional) An integer value. This argument is always ignored. It is defined for compatibility with other Instr functions in other languages.The questions are thus:a) In TM1 MDX queries, does 1 as the 4th argument mean case-insensitive search?b) With the stringer typing etc. anticipated, is this likely to change? If so, how?