remove space from middle of string sql code example

Example: remove all spaces from string sql

SELECT REPLACE(' Hello World ',' ')