SQL: Like vs Contains - Different Results
SELECT MSDS FROM dbo.MSDSSearch3 WHERE CONTAINS(MSDS, 'STYCAST')

SELECT MSDS FROM dbo.MSDSSearch3 WHERE MSDS like '%STYCAST%'

'STYCAST 50300 LV'

'STYCAST 50300 LV'
'STYCAST 2851 BLACK'

SELECT MSDS FROM dbo.MSDSSearch3 WHERE CONTAINS(MSDS, '"STYCAST*"')