Thanks in advance and will give points to the responders,
Iam trying to replace '000000000' in one filed for 10000 customers. with my logic i am able to change for 1000 customers. please help me on to change for 10000 customers at a time. am using UPDATE command.