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

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Tue, 27 Nov 2001 11:42:19 GMT
Message-ID: <3c037ba8.1238830@news>

David doodled thusly:

>
>But will for this query
><---------------------
>SQL> select * from rw_field
> 2 WHERE (rw_field.RECORD_ID=161) AND (rw_field.FIELD_NAME like 'New%');
>

Is FIELD_NAME a CHAR column? If so, you need to right-pad your string with blanks to get a match. The "like" works because it matches anything to any length after 'New'. If it is not CHAR, then check it doesn't have trailing blanks anyway. Some tools will insert these.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Tue Nov 27 2001 - 05:42:19 CST