Re: Character based searchs in isql 4.1/online 5.0

Posted in 1993

Bob Baskett — Sat, 21 Aug 93 14:36:30 MST — source: Informix-list mailing list archive (1991-1998)

yes, the index will help. how long does it take if you change the word 'MATCHES' for '='. you only need to use matches if you are wild-carding some portion of the string. regards, ------------------------------------------------------------------------------ | . . Bob Baskett | ... ... Software Engineer, DBA | ..... ..... Business Systems Integration Group | .. ... .. Semiconductor Products Sector | . . . Mesa, AZ | | Motorola, Inc ------------------------------------------------------------------------------ Sun 690-MP Informix Versions: Online - 5.00.UC2 ISQL - 4.10.UD1 4GL-RDS- 4.10.UC1 ------------------------------------------------------------------------------