trim spaces in sql server 2014 code example

Example: sql trim all spaces

Select TRIM (' Word  ')