What I want to do is to change Column ticket to where BookingId = tbookingID and change Column ticket to NO what I am getting is changing column ticket to where column ticket = NO Liam Liam Lambert liamlambert at mac.com IRELAND