title: Include wildcards in sql server in the values themselves - not when searching with LIKE
body: <p>Is there a way to include wildcards in sql server in the values themselves - not when searching with LIKE?</p>
  
  <p>I have a database that users search on. They search for model numbers that contain different wildcard characters but do not know that these wildcard characters exist. </p>
  
  <p>For example, a model number may be 123*abc in the database, but the user will search for 1234abc because that's what they see for their model number on their unit at home. </p>
  
  <p>I'm looking for a way to allow users to search without knowledge of wildcards but have a systematic way to include model numbers with wildcard characters in the database.</p>