You'd probably be able to get better and more detailed answers on this from Microsoft's website itself:

http://msdn.microsoft.com/en-us/library/ms203721(SQL.90).aspx

Esentially it's a mechanism to allow queries that can find a word or word pattern anywhere in large character based datatyped columns such as VARCHAR or NVARCHAR.