Just found some thing new. You haven't initalized blnFirstWhere to true when you start the procedure, so you won't ever get the WHERE to come up.

This could sort out all your problems (Maybee, just Maybee)


Ian

[Edited by Ianpbaker on 07-18-2000 at 11:42 AM]