SELECT values, then the next, then the next, etc

[TomBarrand]

I have the following SQL statment. If it returns say 5 values I want to do something with the first value, get the next value, then the next, etc until I get to the last value. Is this possible? Is there some sort of MoveNext function.

Select FOB_No FROM FOB WHERE Purch_Ord_Line_No = 10

 

[Spellman]

Are you using this in programming code or as stand alone SQL?

 

[TomBarrand]

Ideally in standalone SQL, if this is not possible I will have to use a VBScript I think. SQL is the preferred option though.

Thanks for your help

 

[Spellman]

Sorry not much use to you on that one mate.

 

[Rajeswari]

I think Cursors may help u. @@FETCH_STATUS parameter helps u to find end of file.