title: In SQL, accept a user prompt via keyboard, then add a wildcard to pull everything like it
body: <p>I can't seem to get this to work. I need to type in a word or letter, and return everything that contains that letter or word at the beginning of it's entry. My code:</p>
  
  <pre><code>ACCEPT v_name PROMPT 'Enter the name or letter: '
  
  select *
  from customer c
  where UPPER(c.name) LIKE UPPER('%'||$$v_name||'%');
  </code></pre>
  
  <p>I am using sql developer and sql plus.</p>