title: select * from table_name where column like '&nbsp'
body: <p>I need to find records containing html code such as '&amp;nbsp' But when I try to run the <code>select * from table_name where column like '&amp;nbsp%'</code>
     I got prompt asking for the value of nbsp. I guess the database thinks that nbsp is a parameter. I am wondering if the is an escape character so that I can tell the database that "&amp;" is part of my query string. I tryed '\&amp;nbsp' but didn't work. </p>
  
  <p>My environment is Oracle 9i with sqlplus client.</p>
  
  <p>Thanks.  </p>