Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    6

    Unanswered: Substring as index?

    Is it possible to create an index on a substring of a column?

    For example,

    CREATE INDEX INDEX_NAME ON TABLE1 (SUBSTRING(COLUMN1,3));

    Obviously, that doesn't work.

    Thanks.

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    No. Indexes are on fields.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •