Hi All,
Sorry to start a new thread....................but there was no option to reach you all......
I am having a problem to find the position 'X' in a field (i.e. ARDIAG) as shown below.
Diagnostic array
X X
position('X' in ARDIAG)
SELECT position('X' in ARDIAG) FROM FILE1 WHERE x =95 gives me 12, for the first 'X' ..
How can I know the 2nd 'X' position.......reply soon..
Sorry to start a new thread....................but there was no option to reach you all......
I am having a problem to find the position 'X' in a field (i.e. ARDIAG) as shown below.
Diagnostic array
X X
position('X' in ARDIAG)
SELECT position('X' in ARDIAG) FROM FILE1 WHERE x =95 gives me 12, for the first 'X' ..
How can I know the 2nd 'X' position.......reply soon..
Comment