how to compare 2 adjacent records of a particular filed

[shafee212]

how can 2 adjacent records can be compared

for eg i want to compare adjacent records of ps_comp of table ps_mstr

 

[TomBascom]

You could use the BUFFER-COMPARE statement...