Case-insensitive search solution wanted

Posted in 1994

Henri van den Eertwegh — Fri, 18 Nov 1994 09:23:29 GMT — source: Informix-list mailing list archive (1991-1998)

System: SCO Unix r 3.2v4.1 RDS : 4.10.UC2 SE : 4.10.UD2 For a client i need a way to perform a case-insensitive search on fields containing name, address, district and city names. i hoped that something like WHERE UPSHIFT(name) MATCHES "SMITH*" would do the job, but it didn't. Is this possible in later releases of RDS/SE? I know that WHERE name MATCHES "[Ss][Mm][Ii][Tt][Hh]*" works but performance is dreadfully slow on large tables. Any ideas? Henri --/-- Please use e-mail for response (henri@spc.nl) since i'm not a frequent netter. -- ,--__ ====================== H. van den Eertwegh /) ( ) e-mail: henri@spc.nl SPC/Company BV / `-'_/ telfax: (+31)412025225 Molenstraat 61, Oss (____( voice: (+31)412043888