Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Sat, Nov 18 2006 9:37 PM	Permanent Link
Sam Jones	Our experience indicates that doing searches on text indexes only searches for whole words. We are unable to do things like search for '%acme%' How can we do this when searching a text index? Thanks!
Sun, Nov 19 2006 5:06 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Sam >We are unable to do things like search for '%acme%' >How can we do this when searching a text index? You can't. You can do 'acme*' Roy Lambert
Mon, Nov 20 2006 5:08 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Sam, << Our experience indicates that doing searches on text indexes only searches for whole words. We are unable to do things like search for '%acme%' How can we do this when searching a text index? >> Roy is correct. You can use a trailing wildard (*), but not a leading or embedded wildcrd, with full-text searches. -- Tim Young Elevate Software www.elevatesoft.com