Finding a string within specific portions of the data

When you use the FIND command to search for a string, you can limit the search to specific portions of the data you are searching:

• To limit the search for a string to only where it appears as a prefix in the data, specify the PREFIX parameter.
• To limit the search for a string to only where it appears as a suffix in the data, specify the SUFFIX parameter.
• To limit the search for a string to only where it appears as a word in the data, specify the WORD parameter.