Oh, still more good to know info, thank you. We'll search for that, and related products. We don't use substring much, just this one requirement is to locate portions of strings in long product serial number strings, so it isn't really a word-by-word search, but rather a string embedded in a longer string that we need to search on.

--------------

You can still use alltrim(), just make sure that the index expression is of constant size.

Example:


index on padr(alltrim(lastname) + ", " + alltrim(firstname), 30) tag FullName
> I've heard of phdBase, but I thought it was no longer sold/supported... we'll have to look into that.

I have heard similar things, so further investigation is warranted. I don't know whether a replacement product exists, but searching www.hallogram.com for "index" gives many hits. You might start investigating here.

You can create your own word-by-word indices, but I suspect this will be a lot of trouble.