CONTAINS Predicate is exactly what you are looking for.
However, I do not believe it is part of SQL 6.5. In MS-SQL 7.0 a new feature
full-text searching/indexing was added. In which I think CONTAIN relies on?
Any hope of upgrading to 7.0? Or possibly using Verity search capability?
Bill
Willow Gold
http://www.willowgold.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.