Re: Upper case function in index?

--------------244A32E1C2A70D08F1632F26 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit FYI, in Universal Server they've added something called a "functional index". This enables you to create an index on the results of a function. Therefore, you don't need to store it twice (once regular and once in CAPITALS). David David Samson, Senior Database Researcher dsamson@ndsisrael.com NDS Technologies Israel Ltd. +972 2 589-4529 PO Box 23012 Fax: +972 2 589-4578 Jerusalem, Israel Cellular: +972 51 287 481 Xin Zhou wrote: > Hi, there, > > I assume some of you must experience the same situation. I need > building > an index upon people's name. I would like sort them in the order of > either upper case or lower while name field allows mix-cased. I can > not > find a way in Informix to do it so I have to add a column of > single-cased name for sorting purpose only. It is kind of waste, isn't > > it? Can any of you out here shed a light on the issue? > > Thank you in advance. > > Sims > xhsims@erols.com --------------244A32E1C2A70D08F1632F26 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML> FYI, in Universal Server they've added something called a "functional index".&nbsp; This enables you to create an index on the <U>results</U> of a function.&nbsp; Therefore, you don't need to store it twice (once regular and once in CAPITALS). <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; David <P>David Samson, Senior Database Researcher&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dsamson@ndsisrael.com <BR>NDS Technologies Israel Ltd.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +972 2 589-4529 <BR>PO Box 23012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fax: +972 2 589-4578 <BR>Jerusalem, Israel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cellular: +972 51 287 481 <BR>&nbsp; <BR>&nbsp; <P>Xin Zhou wrote: <BLOCKQUOTE TYPE=CITE>Hi, there, <P>I assume some of you must experience the same situation. I need building <BR>an index upon people's name. I would like sort them in the order of <BR>either upper case or lower while name field allows mix-cased. I can not <BR>find a way in Informix to do it so I have to add a column of <BR>single-cased name for sorting purpose only. It is kind of waste, isn't <BR>it? Can any of you out here shed a light on the issue? <P>Thank you in advance. <P>Sims <BR>xhsims@erols.com</BLOCKQUOTE> &nbsp; <BR>&nbsp;</HTML> --------------244A32E1C2A70D08F1632F26--