Could someone assist me on what I need to set in my application or project so that the search won’t be base sensitive? For example, currently if a field in my application form is “Orb”, I can only search it as “Orb”. And if typed “orb” in the search area, the application would say “no records found.” Your quick response to this request would be greatly appreciated. Thanks.
It depends in which version you work,I’m still in 8.1, but afaik there’s a case switch to be found on the sql screen.
Mr. Aducom,
I am using ver 9.xx and I found it in SQL as you have stated. Thank you very much.
Isaiah A.