Using wildcards in fulltext searches

[Andrew Fielden]

I'm trying to speed up a query of the form

... WHERE desc like '%MSDN%'

by using a fulltext index on the 'desc' column in my table.
However, the equivalent fulltext search clause

... MATCH desc AGAINST ('MSDN')

returns rows matching

...w/MSDN Prem...

but not

...w/MSDNPrem...

I've tried modifying my fulltext search with wildcards i.e.

... MATCH desc AGAINST ('*MSDN*')

but this didn't work, I still didn't get the complete set of matches I expected. Does anyone know what search pattern would achieve this? I've searched previous similar threads on this subject, but not found any answers.

Thanks.