Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> query strangness

query strangness

From: Sebastian Degenaar <degenaar_at_adlink.com.au>
Date: Tue, 26 Oct 1999 12:17:59 +1000
Message-ID: <38150F57.EF1C6025@adlink.com.au>


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! Received on Mon Oct 25 1999 - 21:17:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US