Create function dbo.Acronym
(@name varchar(100))
Returns varchar(50) As
Begin
Declare @Acronym varchar(50)

Declare @numbers Table (n int identity(1,1), blah int)
Insert Into @numbers 
Select 1 from master.dbo.syscolumns

Select @Acronym = isnull(@Acronym,'') + Z.letter
From 
	(
	Select top 100 percent letter = substring(' '+A.name,B.n+1,1)
	From (Select name = @name) A
	Inner Join @numbers B
	On substring(' '+A.name,B.n,1) = ' '
	and B.n < len(A.name)+1
	Order By B.n
	) Z

Return @Acronym
End
go
Create Table #myTable (Name varchar(100), abbrev varchar(50))
Insert Into #myTable
Select 'Cheese Balls', null
Union Select 'MC Burger', null
Union Select 'Chicken Pizza', null
Union Select 'Pepsi To Pepsi', null
Union Select 'MC D Special Pizza', null

Select 
	name,
	Abbrev = dbo.Acronym(name)
From #myTable

Drop Table #myTable
go
Drop Function dbo.Acronym

Create function dbo.Acronym (@name varchar(100))
Returns varchar(50) As
Begin
  Declare @Acronym varchar(50);
  declare @i int;
 
  select @name = ' ' + rtrim(@name), @i=2, @Acronym = ''

  while (@i < len(@name)) 
     select @Acronym= @Acronym + 
                      case when substring(@name,@i-1,1) = ' ' 
                      then substring(@name,@i,1) else '' end, 
            @i=@i+1

  Return @Acronym
End