query to find keyword in a column for a table

declare @TableName nvarchar(max)
declare @ColumnName nvarchar(max)
declare @SearchStr2 nvarchar(max)
declare @SearchStr nvarchar(max)
set @TableName='alphaitems_new'
set @ColumnName='iteminfo'
set @SearchStr='FCF Yld'
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')
EXEC
(
'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)
FROM ' + @TableName + ' (NOLOCK) ' +
' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
)