title: SQL Server : How to replace whitespaces(&nbsp, ASCII) in a string with numbers?
body: <p>This works   <code>select replace('string with space',' ','')</code> and returns stringwithspace.</p>
  
  <p>This does not work <code>select replace('8 190',' ','')</code>, it returns 8 190</p>
  
  <p>This is the same <code>select replace('8     190',' ','')</code> returns 8 190.</p>
  
  <p>Why doesn't it work?</p>