title: how to combine firstname and lastname in SQL and search with LIKE
body: <p>I would like to combine <code>FirstName</code> and <code>LastName</code> into one column called <code>'FULL NAME'</code> and search with LIKE in SQL.</p>
  
  <p>Example 1:</p>
  
  <blockquote>
    <p>FirstName : Milan<br>
    LastName: Patel</p>
    
    <p>FullName: Milan Patel</p>
  </blockquote>
  
  <p>Search with: <code>Like '%SomeText%'</code></p>
  
  <p>Example 2:</p>
  
  <blockquote>
    <p>Title: " Meetings: A practical alternative to work."</p>
  </blockquote>
  
  <p>Search: I would like to search the entire word within the give string. ex: work should return the above title.</p>
  
  <p>Here is what I have so far.</p>
  
  <pre><code>SELECT 
      CE.Title, CC.FirstName + ' ' + CC.LastName AS FullName
  FROM 
      EntryTable CE
  JOIN 
      UserTable CC ON CE.EntryId = CC.USerId
  WHERE 
      CC.FirstName LIKE 'n%'
  </code></pre>
  
  <h1>EDIT</h1>
  
  <p>I am getting it there slowly. search is working fine with this query.</p>
  
  <pre><code>    SELECT 
       CE.Title 
      FROM 
       EntryTable CE
      JOIN 
       UserTable CC
      ON 
       CE.EntryId = CC.USerId
      WHERE 
       CC.FirstName  + ' ' + CC.LastName LIKE 's%'
  </code></pre>
  
  <p>BUT it only search for name starting with <code>'s'</code>, i would like to search name starting, ending, contains conditions as well. how can i go about that. please help</p>