ErcanOPAK.com

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