<< That being said it looks like I could use something like %LIKE% to accomplish the same. >>
This will follow the same optimization rules as CONTAINS. If you have a wildcard at the beginning of the matching term then the search cannot be optimized. LIKE can be optimized if the wildcard occurs elsewhere in the matching string. -- Larry
