Re: Case INsensitive search

Jack Parker (jparker@hpbs3645.boi.hp.com) wrote: : I'm thinking that one way to do this, with a correspondinging speed : advantage to boot, is to have a little trigger which updates a column on : the table after every insert/update. Its purpose would be to turn every : such character key into an integer - for case sensitivity you upshift : first. Then when you want a specific value, just use the same algorithm : on the character value and then read using the integer key. The only thing : I don't know off the top of my head is whether you can upshift in an SPL. I dug into this one for a while, and I am pretty sure it is not possible (unless you want to have a table lookup for the upshift, and even worse a huge if-then structure because you cannot index a string with a variable in SPL). Because of limitations like these I have given up on using SPL. Are you listening Informix? Martin -- Martin Andrews andrewm@ccfadm.eeg.ccf.org Section of Neurological Computing Phone (216)444-7485 Cleveland Clinic Foundation Fax (216)445-6617