INDEXING ON A SUBSTRING

Richard Wakema

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

INDEXING ON A SUBSTRING

Need to build an index based upon a substring of a Field in a Table. For
example, a field called CONTROL
has 14 characters.

Here is what a typical entry into the CONTROL field would look like:

MISC 000300052

I need to index the table by the last 5 characters in that field. The
field is a String Type.

Is that possible? How, exactly, would that be done.

In xBase, the line of code would be:

Index On SubStr(CONTROL,10,5) to SomeIndex

Thanks

Richard Wakeman
wake...@thegrid.net

Steve Koters

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:INDEXING ON A SUBSTRING

On Thu, 6 Jan 2000 12:46:49 -0800, "Richard Wakeman" <wake...@thegrid.net>
wrote:

Quote

>Need to build an index based upon a substring of a Field in a Table. For
>example, a field called CONTROL
>has 14 characters.

>Here is what a typical entry into the CONTROL field would look like:

>MISC 000300052

>I need to index the table by the last 5 characters in that field. The
>field is a String Type.

>Is that possible? How, exactly, would that be done.

>In xBase, the line of code would be:

> Index On SubStr(CONTROL,10,5) to SomeIndex

AFAIK, you can only do this with dBASE or xBASE tables using an expression
index. In Delphi, this looks like:

Table1.AddIndex('IdxName', 'UBSTR(CONTROL, 10, 5)',
[ixExpression], '');

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Steve Koterski "Health nuts are going to feel stupid someday,
Felton, CA lying in hospitals dying of nothing."
-- Redd Foxx

Other Threads

1. INDEX ON A SUBSTRING

2. INDEX ON A SUBSTRING

3. Temporary Index on a SubString of A field ????

4. Index - Creating new MDX index without previous index to copy

5. SQL use of SUBSTRING() ?

6. Searching for a substring

7. INTERBASE: Anybody solved missing of SUBSTRING...

8. SQL help : SUBSTRING

9. Locating substring in field

10. SEARCHING for SUBSTRING in MEMO - field