How to Remove Extra Space from a String in SQL Server

DECLARE @NAME AS VARCHAR(100)

SET @NAME = 'Arka      G      Gupta'

SELECT @NAME AS [String with extra spaces],

REPLACE(REPLACE(REPLACE(@NAME,CHAR(32),'()'),')(',''),'()',CHAR(32))

AS [String without extra spaces]

OUTPUT--

String with extra spaces	String without extra spaces
Arka      G      Gupta	Arka G Gupta