Execute the following SQL Server T-SQL script in Management Studio Query Editor to demonstrate searching for the "pre" prefix.

-- SQL full-text index - SQL full-text search
USE AdventureWorks;
GO
 
SELECT   ID = ProductDescriptionID,
         ModifyDate = convert(CHAR(10),ModifiedDate,110),
         [Desc. contains "Pre" prefix] = DESCRIPTION
FROM     Production.ProductDescription
WHERE    CONTAINS(DESCRIPTION,' "pre*" ')
ORDER BY ModifyDate;
 
GO
 
/* Partial results
 
ID          ModifyDate  Desc. contains "Pre" prefix
457         06-01-2003  ....aluminum frame, and steering that allows precision control.
633         06-01-2003  Stout design absorbs shock and offers more precise steering.
647         06-01-2003  ...er and wall-thickness required of a premium mountain frame.
892         06-01-2003  New design relieves pressure for long rides.
1214        06-01-2003  amois construction eliminates pressure points.
1605        06-01-2003  ...s à un vélo tout-terrain de premier choix. Le....

*/