removing space from between strings in sql code example

Example: remove all spaces from string sql

SELECT REPLACE(' Hello World ',' ')