UPDATE    dbo.BatchDetails
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.BatchH
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.BillDetails
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.BillFeeBreakDown
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.BillHeader
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.CaseContacts
SET              CaseCODE = REPLACE(CaseCODE, '''', '_')
WHERE     (CaseCode LIKE '%''%')

UPDATE    dbo.CaseMaster
SET              CSCODE = REPLACE(CSCODE, '''', '_')
WHERE     (CSCode LIKE '%''%')

UPDATE    dbo.CaseMaster
SET              CSClientCDE = REPLACE(CSClientCDE, '''', '_')
WHERE     (CSClientCDE LIKE '%''%')

UPDATE    dbo.CaseMasterClosed
SET              CSCODE = REPLACE(CSCODE, '''', '_')
WHERE     (CSCODE LIKE '%''%')

UPDATE    dbo.CaseMasterCLosed
SET              CSClientCDE = REPLACE(CSClientCDE, '''', '_')
WHERE     (CSClientCDE LIKE '%''%')

UPDATE    dbo.CaseUDFAnswers
SET              CaseCODE = REPLACE(CaseCODE, '''', '_')
WHERE     (CaseCODE LIKE '%''%')

UPDATE   dbo.ChequeRequisitionDetail
SET              Matter = REPLACE(MATTER, '''', '_')
WHERE	  (MATTER LIKE '%''%')

UPDATE   dbo.ChequesForPrinting
SET              Matter = REPLACE(MATTER, '''', '_')
WHERE	  (MATTER LIKE '%''%')

UPDATE   dbo.Children
SET              Contact = REPLACE(Contact, '''', '_')
WHERE	  (Contact LIKE '%''%')

UPDATE    dbo.client
SET              CLCODE = REPLACE(CLCODE, '''', '_')
WHERE     (CLcode LIKE '%''%')

UPDATE    dbo.ClientContacts
SET              CLCODE = REPLACE(CLCODE, '''', '_')
WHERE     (CLcode LIKE '%''%')

UPDATE    dbo.CloseCaseContacts
SET              CaseCODE = REPLACE(CaseCODE, '''', '_')
WHERE     (CaseCODE LIKE '%''%')

UPDATE    dbo.Closed
SET              CODE = REPLACE(CODE, '''', '_')
WHERE     (code LIKE '%''%')

UPDATE    dbo.Closed
SET              ClientCODE = REPLACE(CLientCODE, '''', '_')
WHERE     (Clientcode LIKE '%''%')

UPDATE    dbo.ClosedCaseUDFAnswers
SET              CaseCODE = REPLACE(CaseCODE, '''', '_')
WHERE     (CaseCode LIKE '%''%')

UPDATE    dbo.closediary
SET              CaseCODE = REPLACE(CaseCODE, '''', '_')
WHERE     (CaseCODE LIKE '%''%')

UPDATE    dbo.closeDiaryAttachments
SET              CaseCODE = REPLACE(CaseCODE, '''', '_')
WHERE     (CaseCODE LIKE '%''%')

UPDATE    dbo.ClosedMatterLedger
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.CompositeBillBreakDown
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.CompositeBillDetail
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.CompositeBillFees
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.CompositeBillHeader
SET              CompMatter = REPLACE(CompMatter, '''', '_')
WHERE     (CompMatter LIKE '%''%')

UPDATE    dbo.ContactCategories
SET              Contact = REPLACE(Contact, '''', '_')
WHERE     (Contact LIKE '%''%')

UPDATE    dbo.ContactHistory
SET              Contact = REPLACE(Contact, '''', '_')
WHERE     (Contact LIKE '%''%')

UPDATE    dbo.ContactLinks
SET              Contacta = REPLACE(Contacta, '''', '_')
WHERE     (Contacta LIKE '%''%')

UPDATE    dbo.ContactLinks
SET              Contactb = REPLACE(Contactb, '''', '_')
WHERE     (Contactb LIKE '%''%')

UPDATE    dbo.contactPhoneNos
SET              Contact = REPLACE(Contact, '''', '_')
WHERE     (Contact LIKE '%''%')

UPDATE    dbo.contactRequisition
SET              TempContactRef = REPLACE(TempContactRef, '''', '_')
WHERE     (TempContactRef LIKE '%''%')

UPDATE    dbo.contactRequisition
SET              NewContactRef = REPLACE(NewContactRef, '''', '_')
WHERE     (NewContactRef LIKE '%''%')

UPDATE    dbo.contacts
SET              CODE = REPLACE(CODE, '''', '_')
WHERE     (code LIKE '%''%')

UPDATE    dbo.CostTransGathering
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.Csaccounts
SET              AccaseCode = REPLACE(AccaseCode, '''', '_')
WHERE     (AccaseCode LIKE '%''%')

UPDATE    dbo.DebtAccounts
SET              AccaseCode = REPLACE(AccaseCode, '''', '_')
WHERE     (AccaseCode LIKE '%''%')

UPDATE    dbo.DebtCostingLedger
SET              MatterCode = REPLACE(MatterCode, '''', '_')
WHERE     (MatterCode LIKE '%''%')

UPDATE    dbo.DebtorsLedger
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.DebtorsLedger
SET              Client = REPLACE(Client, '''', '_')
WHERE     (Client LIKE '%''%')

UPDATE    dbo.Deeds
SET              Contact = REPLACE(Contact, '''', '_')
WHERE     (Contact LIKE '%''%')

UPDATE    dbo.diary
SET              CaseCODE = REPLACE(CaseCODE, '''', '_')
WHERE     (CaseCODE LIKE '%''%')

UPDATE    dbo.diaryAttachments
SET              CaseCODE = REPLACE(CaseCODE, '''', '_')
WHERE     (CaseCODE LIKE '%''%')

UPDATE    dbo.diarytemp
SET              CaseCODE = REPLACE(CaseCODE, '''', '_')
WHERE     (CaseCODE LIKE '%''%')

UPDATE    dbo.EMailAttachments
SET              EACaseCODE = REPLACE(EACaseCODE, '''', '_')
WHERE     (EACaseCODE LIKE '%''%')

UPDATE    dbo.FileManagerItems
SET              ClientCode = REPLACE(ClientCode, '''', '_')
WHERE     (ClientCode LIKE '%''%')

UPDATE    dbo.FileManagerItems
SET              MatterCode = REPLACE(MatterCode, '''', '_')
WHERE     (MatterCode LIKE '%''%')

UPDATE    dbo.InterestCalcHistory
SET              MatterRef = REPLACE(MatterRef, '''', '_')
WHERE     (MatterRef LIKE '%''%')

UPDATE    dbo.matterLedger
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.MatterLedger
SET              Client = REPLACE(Client, '''', '_')
WHERE     (Client LIKE '%''%')

UPDATE    dbo.matterLedgerClearDown
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.MatterLedgerClearDown
SET              Client = REPLACE(Client, '''', '_')
WHERE     (Client LIKE '%''%')

UPDATE    dbo.matters
SET              CODE = REPLACE(CODE, '''', '_')
WHERE     (code LIKE '%''%')

UPDATE    dbo.matters
SET              ClientCODE = REPLACE(ClientCODE, '''', '_')
WHERE     (Clientcode LIKE '%''%')

UPDATE    dbo.matterTally
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.MemorisedBatchD
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.MemorsiedBatchH
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.MultiBatchD
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.NominalLedger
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.Officers
SET              ContactCode = REPLACE(ContactCode, '''', '_')
WHERE     (ContactCode LIKE '%''%')

UPDATE    dbo.OutlayTransfer
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.PendingOutlay
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.RBatchD
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.RBatchH
SET              Matter = REPLACE(Matter, '''', '_')
WHERE     (Matter LIKE '%''%')

UPDATE    dbo.RecentMatterList
SET              Matter = REPLACE(MATTER, '''', '_')
WHERE	  (MATTER LIKE '%''%')

UPDATE    dbo.SupplierLedger
SET              Matter = REPLACE(MATTER, '''', '_')
WHERE	  (MATTER LIKE '%''%')

UPDATE    dbo.TestTable
SET              MatterCode = REPLACE(MatterCode, '''', '_')
WHERE	  (MatterCode LIKE '%''%')

UPDATE    dbo.TimeDayBook
SET              Matter = REPLACE(Matter, '''', '_')
WHERE	  (Matter LIKE '%''%')

UPDATE    dbo.TimeEntry
SET              Matter = REPLACE(Matter, '''', '_')
WHERE	  (Matter LIKE '%''%')

UPDATE    dbo.TransferList
SET              Matter = REPLACE(Matter, '''', '_')
WHERE	  (Matter LIKE '%''%')

UPDATE    dbo.Undertakings
SET              Matter = REPLACE(Matter, '''', '_')
WHERE	  (Matter LIKE '%''%')

UPDATE    dbo.Wills
SET              Contact = REPLACE(Contact, '''', '_')
WHERE	  (Contact LIKE '%''%')

UPDATE    dbo.WorkInProgressReport
SET              Matter = REPLACE(Matter, '''', '_')
WHERE	  (Matter LIKE '%''%')