title: IS it possible to use the 'Where' clause in SQL to only show a field containing only letters & Numbers?
body: <p>I want to be able to select only the field where a certain field contains both letters and numbers. for example:</p>
  
  <pre><code>Select [field1], [field2] 
  
  from [db1].[table1] 
  
  where [field2] = *LETTERS AND NUMBERS*
  </code></pre>
  
  <p>Im using SQL Server 2005, also im sorry bu im not a hundred percent sure about the data type of the field because it is on a linked server and un-accessibleat the minute. Hope you can help</p>
  
  <p>:)</p>