remove all white space from text SQL code example

Example: remove all spaces from string sql

SELECT REPLACE(' Hello World ',' ')