Well, not exactly. Username = "FRED" so both conditions have not been met, and when tracing the code, it goes back to the top of the While loop and then exits...so only one row is being returned.

Any ideas?

bob


>>But when I try to run the following code I only get one row (the first above). Any ideas?
>
>Becuase you return from within the while loop if Role matches (and the first row matches).
>
>Einar