SQL Server : How to replace whitespaces(&nbsp, ASCII) in a string with numbers?

Question

This works select replace('string with space',' ','') and returns stringwithspace.

This does not work select replace('8 190',' ',''), it returns 8 190

This is the same select replace('8 190',' ','') returns 8 190.

Why doesn't it work?

Answer 1

The string_pattern needs to contain the ASCII code 160 for the space &nbsp

SELECT REPLACE('8 190', char(160),'')