title: TADOQuery does not return any record
body: <p>I am using Delphi 7 and I have a table named <code>Table_1</code> which has two fields say, <code>IMageCode Varchar(50)</code>, <code>ActImage [Blob in Oracle, VarBinary(Max) in SQL Server]</code>, it has four records inserted including images and respective image code.</p>
  
  <p>When I write a SQL as below in Oracle:</p>
  
  <pre><code>Select * from Table_1 where Upper(ImageCode) ='SUNSET'
  </code></pre>
  
  <p>TADOQuery doesn't return any record, when I check <code>TADOQuery.RecordCount</code> it shows <code>0</code>, when I try to see <code>TADOQuery.IsEmpty</code> it says <code>True</code>. Then same query when I execute in the Oracle editor it returns one record as expected, but in delphi the TADOQuery doen't return any record.</p>
  
  <p>But when I write following simple sql for the oracle database, it returns all four records using TADOQuery:</p>
  
  <pre><code>Select * from Table_1
  </code></pre>
  
  <p>I don't find any issue in SQL server database, as discussed above using TADOQuery.</p>
  
  <pre><code>ADOConnection.Connected := False; 
  ADOConnection.LoginPrompt := False; 
  ADOConnection.ConnectionString := &lt;Connection String&gt;; 
  ADOConnection.Connected := True; 
  ADOQuery1.Connection := ADOConnection; 
  with ADOQuery1 do begin 
    Active := False; 
    SQL.Clear; 
    //SqL.Add('Select * from Table_1 where Upper(ImageCode) = ' +    QuotedStr(Uppercase(Trim(edtImageCode.Text)))); 
    SqL.Add('Select * from Table_1 where Upper(ImageCode) = ''SUNSET'''); 
    Active := True; 
  end; 
  </code></pre>
  
  <p>Could anybody put focus what could be the issue?</p>