Re: query strangness

From: <michael_bialik_at_my-deja.com>
Date: Tue, 26 Oct 1999 21:43:59 GMT
Message-ID: <7v57av$mrg$1@nnrp1.deja.com>

Hi.

Is it possible that you have case sensitive data? If yes - try

SELECT * FROM USER.CUSTOMER where UPPER(LASTNAME) = UPPER('test1');

Use FUNCTION BASED INDEXES in 8i - otherwise performance will be awfull.

HTH. Michael.

In article <38150F57.EF1C6025_at_adlink.com.au>, Sebastian Degenaar <degenaar_at_adlink.com.au> wrote:
> I am having difficulty in oracle 8i for Win NT just doing a simple
query
> on a varchar2 field. It works fine to query on any integer field,
> however if I try for example;
>
> select * from USER.CUSTOMER where LASTNAME = 'test1' i get no rowset.
> Why is this. It seems to work on some varchar fields and not others.
>
> Any help greatly appreciated!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 26 1999 - 16:43:59 CDT