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

Try this one:
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 like 'New MSCI Industrial Class Code%');

Maybe there are some blanks.

Alex

Użytkownik "David" <david.wynter_at_btclick.com> napisał w wiadomości news:5MKM7.82128$JZ3.230140_at_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

>

>