Case sensitive search

[wtian]

I am trying to search against texis database.
I need one of the search word to be case sensitive or to be taken literally. I tried:

(oracle,pelplesoft,\RSAP\I)

I am searching for oracle or pelplesoft or SAP,
where I want SAP part to be case sensitive. Ofcause it did not work for me. Some where on the message board I sense that I need to make case sensitive index on my fields.

Is this true? or I just do not know how to the casesensitive search? Please use above example to show me how I can accomplish this.

If I need do case sensitive index, how expensive is that? Please also include a direct example for the index expression.

Thanks.

[Kai]

Metamorph indexes cannot be made case-sensitive. Also, you cannot use special pattern matchers such as REX inside a parenthetical set list; ie. "\RSAP\I" in your query is taken literally, not as a REX expression.

You are correct in that using \R with a REX expression will get case-sensitivity for that term, but you must use "/" at the start of the set to indicate REX to Metamorph; your query becomes:

@0 oracle peoplesoft /\RSAP

But since REX and other special pattern matchers are unindexable, and the REX set is OR'd, this will cause a linear search, which is very slow.

There's no way in one Metamorph query to OR your three terms, and get case-sensitivity for SAP, without a complete linear search.