title: SQL concatenating strings?
body: <p>I have a query that takes input from the end user and compares it to 2 columns individually, and the two columns concatenated.</p>
  
  <pre><code>SELECT f_name, l_name, (f_name + ' ' + l_name) AS full_name
  FROM users_table
  WHERE f_name = user-input
     OR l_name = user-input
     OR 'full_name' = user-input
  </code></pre>
  
  <p>Excuse the massive syntax fail, but I assure you it's correct in the program.</p>
  
  <p>It is written in PHP, querying a SQL SERVER 2005 database, and is case insensitive.</p>
  
  <p>Typing one name (first or last) will return correct results, but typing first, then space, then last, returns an empty set.</p>
  
  <p>Any ideas?</p>