Cacher is the code snippet organizer for pro developers

declare @test varchar(500) = 'this is a test'
Select 
  Case 
    when @test like '%' + space(1) + '%' 
      then 'has space' 
    else 'no space' 
  end

declare @test varchar(500) = 'thisisatest'
Select 
  Case 
    when @test like '%' + space(1) + '%' 
      then 'has space' 
    else 'no space' 
  end