Trimming in SQL Server

Introduction
 
This blogs describes how to remove space from a string using sql statement.
 
Using Replace trimming can be done, see the below code
 
SELECT replace('A B C',' ','')
 
Out Put
 
ABC