Oninit cdi / Archive
Talk to an expert →

Re: Problem with performance!

Posted in 1998

SaTriGuy — — source: Informix-list mailing list archive (1991-1998)

>How to make my SQL quicker: SELECT * FROM tablex WHERE >field1 MATCHES >'[K,k][O,o][P,p]*' I realize that this will not help now, but 7.3 supports an "internal" upper() function so that you can say "where upper(field1) matches 'KOP*' Madison Pruet