SELECT REPLACE(REPLACE(REPLACE(' With this query you select single spaces',' ','<>'),'><',''),'<>',' ')
OUTPUT:
With this query you select single spaces
If you wanna remove all the spaces between words:
SELECT REPLACE(' With this query you select single spaces',' ','')
OUTPUT:
Withthisqueryyouselectsinglespaces