title: Searching words in a database
body: <p>I need to improve the search on a website which has a search box that only searches for the exact same characters. If I type in hyperlink it will return everything starting with hyperlink but not anything such as contenthyperlink, _hyperlink, etc. Here is my sql query - </p>
  
  <pre><code>    select          O_ObjectID, 
                  rtrim(O_Name) as O_Name
      from            A_Object
      where           O_Name like @NamePrefix + '%'
      order by        O_Name
  </code></pre>