Good Morning! Yes it is to be permanent so the script from SSC is the one. Thanks though! He knows im not a script writer and we are to test...

Thanks very much for all your help, you are right i am not ready or very willing to be writing scripts at my old job we had developers who did...

Thanks very much for all your help this is what i have gone with...not tested it yet but hoping it will work!

WHILE (SELECT accountNumber FROM payments) Is Not NULL

...

Thanks very much! If i use that script can i get it to amend all the card details in the table without having to put in the card numbers? Sorry...

Hi there thanks for your reply but i have never written a script before so i dont understand at all. Its SQL on Java too so i have even less...