Case insensitive query.

From: Thomas Kim <thomas_at_sde.mdso.vf.ge.com>
Date: 1995/10/03
Message-ID: <44rsj2$4gt_at_tel.den.mmc.com>#1/1

In Oracle is there a way to perform a case insensitive query? For example: Select * from table where col1 LIKE 'toys', where a correct response will include TOYS, Toys, toys, or ToYs etc. Received on Tue Oct 03 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Joel D. Elkins: "Re: Case insensitive query."
Previous message: Stephanian: "Re: Help :::ROLES"
Next in thread: Joel D. Elkins: "Re: Case insensitive query."
Reply: Joel D. Elkins: "Re: Case insensitive query."
Reply: McGrath Glenda: "Re: Case insensitive query."
Maybe reply: Jacob Love: "Re: Case insensitive query."
Reply: ccrissma_at_ucs.att.com: "Re: Case insensitive query."
Maybe reply: Bobby S. Mukundan: "Re: Case insensitive query."
Maybe reply: Andrew McAllister: "Re: Case insensitive query."
Reply: G. Cristian Palma A.: "Re: Case insensitive query."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message