I have a client that is planning on changing banks.  The problem is that they have over 1000 credit cards saved.  They are using PAYA, but the problem is that in Sage 300 the credit card is associated with a bank.  I have been told that when they change banks they will have to get all the credit card numbers and re-enter them in the system.  Is there a way in SQL to just changes the bank ID that is associated with the credit card?

TIA

Mike Ericksen