Once you have created your full-text indexes, you are ready to start using them in your queries. There are some special commands built into Transact-SQL that are specifically used in full-text searching.
These are the special commands:
Let us look at some examples of the various commands in the SlideShow below. In each situation, the value in the Notes text column in the Employees table for EmployeeID 101 will be the following:
Free Text - Query
NINAH: change to 2 of the graphics in the flipbook: queries_030fb.gif and queries_04fb.gif- will come from Joward.
In the next lesson, we will review the information covered in this module.