Declare @firstname varchar(10)

set @firstname = 'John   '
select With_Spaces_EQ = case when
			@firstname = 'John   '
			then 'True' else 'Not True' end

Set @firstname = 'John'
select No_Spaces_EQ = case when
			@firstname  = 'John   ' 
			then 'True' else 'Not True' end

set @firstname = 'John   '
select With_Spaces_DataLen = case when
			@firstname = 'John   ' and DATALENGTH(@firstname) >= 7 
			then 'True' else 'Not True' end

Set @firstname = 'John'
select No_Spaces_DataLen = case when
			@firstname  = 'John   '  and DATALENGTH(@firstname) >= 7 
			then 'True' else 'Not True' end

Set @firstname = 'John   '
select With_Spaces_Like = case when
			@firstname LIKE 'John   '  
			then 'True' else 'Not True' end

Set @firstname = 'John'
select No_Spaces_Like = case when
			@firstname  LIKE 'John   '  
			then 'True' else 'Not True' end

01  String-Fields.
    05  String-1       Pic X(20) Value 'Hello'.
    05  String-2       Pic X(40) Value 'Hello        '.

If String-1 = String-2 
   Display "True"
Else Display "Not a match".