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))';