David,
Check your case setting or just set case off and try again.
Bernie Lis
----- Original Message -----
From: "David Torre" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, January 25, 2006 8:50 PM
Subject: [RBASE-L] - Strange result for SQL query
Hello,
I'm having a hard time figuring this out:
query 1:
R>select labels from invoice where order_date=01252006
labels
--------
MSI
MSI
MSI
TCL
ACC
MSI
TCL
IOM
query 2:
R>select labels from invoice where order_date=01252006 and labels='tcl'
-WARNING- No rows exist or satisfy the specified clause. (2059)
As you can clearly see, TCL is in the labels column, but when I add a
constraint to narrow the results to only show TCL, nothing comes up. Any
ideas?
