>Is There any SQL Commands equivelant to DO WHILE or SCAN WHILE.
No, but what do you want your SQL to show you ?
Benn Kjaer
MS Certified Professional - Visual Foxpro
"There is something rotten in the state of Denmark"
"Why make user-friendly programs, when there aren’t any friendly users :o)"