Re: Case INsensitive search

Posted in 1995

Mike Aubury — Sun, 22 Oct 1995 14:36:36 GMT — source: Informix-list mailing list archive (1991-1998)

one way is using the matches where colname matches "[Jj][Oo][Nn][Ee][Ss]" i did write a stored procedure to do upshifting, but when applying this to all the rows in the table for the search it got VERY slow! -- Mike Aubury