title: How to do a FREETEXTTABLE across multiple multiple columns and multiple terms with ranking?
body: <p>I've got a customer table like this:</p>
  
  <p>ID*,
  Title,
  FirstName,
  MiddleNames,
  LastName,
  CompanyName</p>
  
  <p>All string fields are nullable.</p>
  
  <p>I need to be able to offer the user a fuzzy search. So, for example, they could enter the following searches and it would bring back ranked results:</p>
  
  <p>"BOB"
  "BOB JONES"
  "BOB JON*"
  "MR JONES"
  "BOB DAVE JONES"
  "B D JONES"
  "BOB JONES ACME CORP"
  "ACME CORP"
  "ACME BOB"
  etc.</p>
  
  <p>My problem is that there doesn't seem to be a way to do wildcard/LIKE% matches. So if there is a surname "JONESY", searching "JONES" doesn't match it.</p>
  
  <p>In an ideal world, I'd like to CONCATENATE all the string columns in to a single column and then do my fuzzy search on that, because the ranking would be better.</p>
  
  <p>Can anybody tell me how to either do wildcard searches OR search on CONCATENATED fields?</p>
  
  <p>Thanks,</p>
  
  <p>Simon.</p>