Strange Query error- please explain
From: John Duska <duska_at_srfs.pitt.edu>
Date: 1996/08/22
Message-ID: <4vhtl3$2uk_at_usenet.srv.cis.pitt.edu>#1/1
Date: 1996/08/22
Message-ID: <4vhtl3$2uk_at_usenet.srv.cis.pitt.edu>#1/1
When I query a row in a database using "where trandate = '21-aug-96'" I
get 'no rows' returned. But if I do the same query using "where trandate
like '21-aug-96'", I get 1 row returned! The one row is the correct
answer. What is causing this ananomly? This is Oracle 6.0, btw.
thanks,
John
--Received on Thu Aug 22 1996 - 00:00:00 CEST
============================================================
John M. Duska | Systems Analyst mailto:duska_at_srfs.pitt.edu | Information Resources http://www.pitt.edu/~pauj4m | University of Pittsburgh
============================================================