Re: Case Sensitivity in select

From: ANDRE <jy.andre_at_progifinance.fr>
Date: 1999/08/26
Message-ID: <37C529E1.E030A795_at_progifinance.fr>#1/1


Sure,
Use UPPER or LOWER Function like :
UPPER(Field)='HELLO' or LOWER(Field)='hello' Both retrieve HELLO, HEllo, Hello, HeLlO, .....

JY ANDRE Stu wrote:

> Is it possible to set a parameter which will make a select statement
> case insensitive. i.e. so that select * from words where word='hello'
> will bring back records where word='HELLO' or 'Hello'.
Received on Thu Aug 26 1999 - 00:00:00 CEST

Original text of this message