title: SQLServer Stored Procedure
body: <p>I would like to hear if any of you have an idea to do the following:
  I have one table containing some cardefinitions [id][Company][Mode], this could e.g. be Audi 100, Ford Mustan etc. I then have another field which is a string containing both the car and the model, this could be "Ford Mustang 2.5T", I then need to find the correct ID from the cardefinition. I though of doing</p>
  
  <pre><code>@CarDefintion = "Ford Mustang 2.5T"
  Select top 1 CarDefinitionId 
    from dbo.CarModelDefinition 
   where CONTAINS(Model,@Cardefinition) 
     AND Contains(Company, @Cardefinition)
  </code></pre>
  
  <p>But since Model + Company is not unique I get this error: <em>"Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'dbo.CarModelDefinition' because it is not full-text indexed."</em>
  Does anyone have an idea of how I can solve this?</p>