Re: how to do case insensitive text literal comparison?

OraSaurus wrote:

> Yes. Its called the ConText Option and it costs a bundle! But, the 'decostataylor'
> example sounds like a problem with data and access standards and methods.

I just read the article at http://ntsolutions.oracle.com/products/oco/html/xctxfov7.htm about context option. It seems this is only for documents, not for what we're used to calling tables, or correct me? For example, when it talks about text indexing, "Each word in the document set is stored in the text index". Suppose we have "john", "doe", "123456", "M", "10-23-66" in a row of a table. When we store this as a text option document, what will be made into indexes? Everything?

My problem with "decostataylor" is indeed a data standard problem. Our Human Resources sends us a table 2-3 times a week. I need to pull some rows out and insert into another table running a script at midnight. The HR table contains a lot of rows where the usage of '-' and ' ' etc. is inconsistent (the name column contains "van de fries" and "van de fries" e.g.). The easiest way for me is simply ignore them first and then do a pattern matching. It'll be bad if I mistakenly match "de fries" with "def ries"(is this a possible name?) because of my WHERE REPLACE(name,' ') construct. But this is very rare so I don't care much.

Yong Huang
Email:yong_at_shell.com Received on Tue Oct 27 1998 - 00:00:00 CST