Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    46

    Unanswered: Get index of values in buffer in a SP

    Hi,
    I have a table with one column.
    The column contains a buffer such as:
    "ProductSet productNum productVal productName "
    The table containes many rows.
    I need to know the position of each value.
    What query should i use in a SP that will return me
    1,17,26,46 (the places of the data in the buffer).
    Can it be done?
    Can i retrieve from a table a specific row that i like?
    Thaks
    Yossi

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Get index of values in buffer in a SP

    Originally posted by garfild
    Hi,
    I have a table with one column.
    The column contains a buffer such as:
    "ProductSet productNum productVal productName "
    The table containes many rows.
    I need to know the position of each value.
    What query should i use in a SP that will return me
    1,17,26,46 (the places of the data in the buffer).
    Can it be done?
    Can i retrieve from a table a specific row that i like?
    Thaks
    Yossi
    In Oracle, you could use the INSTR function to search for spaces in the buffer. Probably other DBMSs have a similar function.

Posting Permissions

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