Soundex search with like operator not working

Question

 Soundex search with like operator is not working

 

DECLARE @FirstNameToBeSearch VARCHAR(50) = 'Ronald'

select * from table where Country = 'US' + ' and (Firstname like ''' + @FirstNameToBeSearch + '%'' or DIFFERENCE (Firstname,''' + @FirstNameToBeSearch + ''') in (4))';