DECLARE @char VARCHAR(1),
	@text_in VARCHAR(200),
	@text_out VARCHAR(200), 
	@pos INT

SELECT @text_in = 'Nathan  		Skerl' -- separated by (2) spaces and (2) tabs

If @text_in IS NOT NULL
BEGIN
	SELECT 	@char = '', 
		@text_out = '', 
		@pos = 1

	WHILE @pos <= DATALENGTH(@text_in) 
	BEGIN
		-- set @char to first character
		SET @char = SUBSTRING(@text_in, @pos, 1)

		-- if @char <> A-Z or a-z replace with ''
		IF ASCII(@char) Between 65 And 90 		-- uppercase A-Z
			OR ASCII(@char) Between 97 And 122 	-- lowercase a-z
		BEGIN
			SET @char = @char
		END ELSE
		BEGIN
			SET @char = ''
		END

		-- build output string, increment position
		SET @text_out = (@text_out + @char)
		SET @pos = (@pos + 1)
	END


END
SELECT @text_out

declare @string varchar(100),
	@pos int

select 	@string = 'Nathan  	Skerl',
	@pos = charindex(char(32), @string)

-- replace any TAB with ''
select @string = replace(@string, char(9), '')

-- remove all but 1st space
select @string = substring(@string, 1, @pos - 1) + char(32) + ltrim(substring(@string, @pos, len(@string)))

select @string

-- your table
declare @members_ table (fullname_ varchar(50))
insert into @members_ 
	select 'nathan  	skerl' union 
	select 'deez 	  	 nutz' union
	select 'michael       	 	jackson'

-- temp staging table for string transformations
declare @temp table (test_id int identity(1,1), full_name varchar(50))
declare	@id int,
	@pos int

-- insert all names into temp without any TABS in name
insert into @temp select replace(fullname_, char(9), '') from @members_

-- get max(test_id) to begin iteration 
select @id = max(test_id) from @temp

while @id > 0
begin
	-- get position of space
	select @pos = charindex(char(32), full_name)
	from @temp
	where test_id = @id
	
	-- do update, retain only 1 space
	update @temp
	set full_name = substring(full_name, 1, @pos - 1) + char(32) + ltrim(substring(full_name, @pos, len(full_name)))
	from @temp
	where test_id = @id

	-- decrement id and continue loop
	set @id = @id - 1
end

-- return results
select * from @temp