title: how to select rows that contains non-english characters in sql server 2005(it should filter only non-english chars, not special characters)
body: <p>As my table contains non-English(contains characters in different languages) characters and special characters in a column. I need filter only non-English characters. It should filter any special characters.</p>
  
  <p>i tried using different methods to filter but failed to filter few rows. someone please help me on this. Thanks in advance.</p>
  
  <p>ex: 
  column name <strong>LOCATION</strong> contains following rows :</p>
  
  <p><strong>row 1</strong>: துய இம்மானுவேல் தேவாலயம், North Street, Idyanvillai, Tamil Nadu, India</p>
  
  <p><strong>row 2</strong>:Dr.Hakim M.Asgar Ali's ROY MEDICAL CENTRE™ Unani Clinic In Kerala India, Thycaud    Hospital Road, Opp. Amritha Hotel,, Thycaud.P.O.,, Thiruvananthapuram, Kerala, India</p>
  
  <p><strong>row 3</strong>: ಕಾಳಿಕಾಂಬ ದೇವಿ ದೇವಸ್ಥಾನ, Shivaji Nagar, Davangere, Karnataka, India</p>
  
  <p>As the above contains characters in many language. can any one help me to select only <strong>row 2</strong> thanks.</p>