My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Wildcard search in SQL Server Full Text
The new RSS feed is here
Most people, me included, didn't think it was possible to do a wildcard search with full text in SQL Server. Well you can and whats more you can do it in 2000 as well as 2005.
Okay so you can't do a full wildcard search i.e. "s*n s*b*n" to find Simon Sabin, you can only have your wildcard at the end i.e. "sim*" to find Simon, Simone, Simple, you get the picture.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Wildcard search in SQL Server Full Text