8.1.5 will not return a select row that is actually there?

From: David <david.wynter_at_btclick.com>
Date: Tue, 27 Nov 2001 11:26:08 -0000
Message-ID: <5MKM7.82128$JZ3.230140@NewsReader>

Hello,

I have a table with a couple of hundred rows in it. There is one row that will not return for a select query programatically constructed.
<---------------------

SQL> SELECT rw_field.RW_FIELD_ID, rw_field.RECORD_ID, rw_field.FIELD_NAME, rw_field.FIELD_TYPE,
  2 rw_field.KEY_FIELD, rw_field.DATA_TYPE, rw_field.DESCRIPTION, rw_field.LENGTH,
  3 rw_field.POSITION, rw_field.START_BYTE, rw_field.END_BYTE FROM rw_field   4 WHERE (rw_field.RECORD_ID=161) AND (rw_field.FIELD_NAME='New MSCI Industrial Class Code');

no rows selected
<---------------------

But will for this query
<---------------------

SQL> select * from rw_field
  2 WHERE (rw_field.RECORD_ID=161) AND (rw_field.FIELD_NAME like 'New%');

RW_FIELD_ID RECORD_ID FIELD_NAME
FIELD_ KEY_FIELD DATA_TYPE

----------- --------- -------------------------------------------------- ---

--- --------- ----------
DESCRIPTION

---

---

   LENGTH POSITION START_BYTE END_BYTE --------- --------- ---------- ---------

       8993       161 New MSCI Industrial Class Code
Data           0 Long
New MSCI Industrial Class Code
        8        33        317       323


<--------------------

And the original query works fine with any of the other field_name column values eg.

<--------------------

SQL> SELECT rw_field.RW_FIELD_ID, rw_field.RECORD_ID, rw_field.FIELD_NAME, rw_field.FIELD_TYPE,
  2 rw_field.KEY_FIELD, rw_field.DATA_TYPE, rw_field.DESCRIPTION, rw_field.LENGTH,
  3 rw_field.POSITION, rw_field.START_BYTE, rw_field.END_BYTE FROM rw_field   4 WHERE (rw_field.RECORD_ID=161) AND (rw_field.FIELD_NAME='Taiwan Code');

RW_FIELD_ID RECORD_ID FIELD_NAME
FIELD_ KEY_FIELD DATA_TYPE

----------- --------- -------------------------------------------------- ---

--- --------- ----------
DESCRIPTION

---

---

   LENGTH POSITION START_BYTE END_BYTE --------- --------- ---------- ---------

       8985       161 Taiwan Code
Data           0 String
Taiwan Code
        5        25        269       273

<-------------------

Any explanations?

Thanks

David Received on Tue Nov 27 2001 - 05:26:08 CST