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.