how to avoid white spaces in sql

See more:

SQL

My store procedure as follows

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
 
ALTER proc [dbo].[Presea_RefresherSMS] 
as
begin
   declare @Course varchar(20),

   @NoofStudents varchar(20),
   @Rowcount int,
   @batchid varchar(20),
   @CourseDate varchar(10),
   @OutputString VARCHAR(MAX) 
 
   select @CourseDate =CONVERT(VARCHAR(10), GETDATE(), 101)
   set @OutputString=''
 
   create table #TempTable (course varchar(10), Noofstudents varchar(10))
 
   begin tran
      declare courses Cursor for
 
      select cmn_minor_code as Course_Name,cbm_batch_id as Batch_ID from co_batch_master where cbm_active <> 'D' and cbm_batch_start_dt = '01/13/2014' and cmn_minor_code in('RFPFF','R-AFF','RFPFF_C')
 
      open courses
      fetch next from courses into @Course,@batchid
      while @@Fetch_status = 0 
      begin
         begin tran 
            declare studentcount cursor for
            select count(*) from batch_course_registration a,course_registration b
            where b.cr_bill_no = a.cr_bill_no and a.bcr_batch_id = @batchid and b.cr_active = 'A'

            open studentcount
            fetch next from studentcount into @Rowcount
            while @@Fetch_status = 0
            begin
               SET @OutputString=@OutputString +' ' +@Course +' '+ convert(varchar,LTRIM(@Rowcount))
               fetch next from studentcount into @Rowcount
            end
				
            close studentcount
            deallocate studentcount
         commit tran

         fetch next from courses into @Course,@batchid
      end
		
      close courses
      Deallocate courses
   commit tran

   select @OutputString
end

When i run the above store procedure shows output as follows

exec [Presea_RefresherSMS]

RFPFF                16 R-AFF                16 RFPFF_C              6

But i want output as follows

RFPFF 16 R_AFF 16 RFPFF_C 6

i want to avoid white spaces in my store procedure output.
for that how can i trim the string.

please help me.

Regards,
Narasiman P.

indentation reduced