title: SQL query for finding rows with special characters only
body: <p>I am working with SQL Server 2005.</p>
  
  <p>I need to find out only those rows for which there is a special character in “Body” column. In the following scenario, the result should be only the row with TemplateID = 2.
  How do we write the query for this?</p>
  
  <pre><code>CREATE TABLE #Template (TemplateID INT, Body VARCHAR(100))
  
  INSERT INTO #Template (TemplateID,Body) VALUES (1,'abcd  1234')
  
  INSERT INTO #Template (TemplateID,Body) VALUES (2,'#^!@')
  </code></pre>
  
  <p>Anything other than the following is a special character for this scenario</p>
  
  <pre><code>1) Alphabtes
  
  2) Digits
  
  3) Space
  </code></pre>