Partial Search using LIKE

[dgbaker]

Hi -

With the search function is there a way to allow for partial hits? For example: The document name is BugsBunny and when search for Bun can it come back with BugsBunny.

It seems the search must be exact word and not using a LIKE on the query - %bun%

Thanks
David

[steinm]

Hi -

With the search function is there a way to allow for partial hits? For example: The document name is BugsBunny and when search for Bun can it come back with BugsBunny.

It seems the search must be exact word and not using a LIKE on the query - %bun%

The regular database search uses LIKE, but the full text search doesn't. The full text search doesn't use the database at all.

Uwe

[dgbaker]

Hi -

With the search function is there a way to allow for partial hits? For example: The document name is BugsBunny and when search for Bun can it come back with BugsBunny.

It seems the search must be exact word and not using a LIKE on the query - %bun%

The regular database search uses LIKE, but the full text search doesn't. The full text search doesn't use the database at all.

Uwe

Hi Uwe, thanks for the information. I will take a look a Lucene to see what I can do then. Thanks.