>Hello, All !
>I'm looking for the advice on SQL. I am SELECTing records from a table. Let's say I have fields F1 and F2, and F1 must be true, if for the PREVIOUS record in the resulting set field F2 == "smthg". Is there any simple way to do this using SQL?
>TIA,
>Alex.
run sql to cursor. then use the cursor in another area (so you can write to it), and scan the cursor making the F1 field true if next rec F2 == 'smthg'