title: Special Character in SQL
body: <p>I have a problem with a special character inserted in a table of SQL Server 2008 R2. 
  The point is that when i'm trying to insert a string with the character º (e.g. 3 ELBOW 90º LONG RADIUS) in the table this appears like this: 3 ELBOW 90� LONG RADIUS, and when i'm trying to select all the rows that contains the character � the result is null.</p>
  
  <p>I tried to make the select with ASCII by making this:
  select * from itemcode where description like '%'+char(63)+'%'</p>
  
  <p>and make this to know that the ASCII of that symbol is 63:</p>
  
  <p>select ASCII('�')</p>
  
  <p>But that doesn't work.
  What i must do to select all the rows that have that character and what should i do to make that SQL recognize the character º?</p>
  
  <p>Thanks</p>