Yeah I think you need Intelligent and Efficient bosses to recognize Intelligence and Efficiency!! :laugh:

My friends call me a s***bag because I automate my work when I was hired to do it manually. Am I?

Here's a generic example:

create table t (s sysname)
insert into t select 'this is the reason that I did this. '

-- convert tabs to spaces
update	t set s = replace(s, '	',' ')
where	charindex('	', s) > 0

-- now do the work.
while 1=1
begin
	update t
	set		s = substring(s, 1, charindex('  ', s, 1)-1) + ' ' + ltrim(substring(s,charindex('  ', s, 1), 8000))
	where	charindex('  ', s, 1) > 0

	if @@rowcount = 0
		break
end

select	s
from	t