Case Insesitive Search.

Posted in 1999

Bryan Sapot — Tue, 29 Jun 1999 16:38:39 -0500 — source: Informix-list mailing list archive (1991-1998)

How can I do a case insesitive search? Or can I.. Please email responses.. Thank Bryan -- ----------------------------------------------------------- Bryan Sapot bsapot@lawless-tech.com Lawless Technology "Get a life get Linux"

↪ replying to Bryan Sapot

Tom Grenier — Wed, 30 Jun 1999 11:46:20 -0400 — source: Informix-list mailing list archive (1991-1998)

Which engine? With >= 7.30 there are built-in functions upper and lower. Prior to 7.30 you have to write a stored procedure -- and it is a real dog. There is probably one posted on the IIUG site, and I have a copy of one that was posted here around a year ago. If you want it I can email. Tom Bryan Sapot wrote: > How can I do a case insesitive search? Or can I.. > > Please email responses.. > > Thank > Bryan > -- > ----------------------------------------------------------- > Bryan Sapot bsapot@lawless-tech.com > Lawless Technology "Get a life get Linux"

↪ replying to Bryan Sapot

Art S. Kagel — Wed, 30 Jun 1999 13:52:45 -0400 — source: Informix-list mailing list archive (1991-1998)

You cannot really. With IDS 7.3x there is the UPPER and LOWER functions but a filter using these cannot use any indexes. The best solution is to add a column containing UPPER(lookup_column) to the table or to another table with the same keys you can then join back to filter. Art S. Kagel Bryan Sapot wrote: > > How can I do a case insesitive search? Or can I.. > > Please email responses.. > > Thank > Bryan > -- > ----------------------------------------------------------- > Bryan Sapot bsapot@lawless-tech.com > Lawless Technology "Get a life get Linux"

↪ replying to Art S. Kagel

June Tong — Thu, 08 Jul 1999 04:55:40 GMT — source: Informix-list mailing list archive (1991-1998)

All true, although I'd quibble that perhaps the "best" solution is to get IUS (or whatever it's called now) and create an index on UPPER (lookup_column). June june_t@hotmail.com Still alive -- just when you thought it was safe to come out with the chocolate... Please do not send Informix questions to this account. I would add 'Please do not send spam to this account' but I suppose I would be wasting my bits. Art S. Kagel wrote: > You cannot really. With IDS 7.3x there is the UPPER and LOWER > functions but a filter using these cannot use any indexes. The best > solution is to add a column containing UPPER(lookup_column) to the table > or to another table with the same keys you can then join back to filter. > > Art S. Kagel > > Bryan Sapot wrote: > > > > How can I do a case insesitive search? Or can I.. > > > > Please email responses.. > > > > Thank > > Bryan > > -- > > ----------------------------------------------------------- > > Bryan Sapot bsapot@lawless-tech.com > > Lawless Technology "Get a life get Linux"