UPDATE custbranch SET brname = 'Six Sigma Academy',
						braddress1 = '89 Roberston Road',
						braddress2 = '',
						braddress3 = 'Suva',
						braddress4 = '',
						braddress5 = '',
						braddress6 = '',
						lat = '0',
						lng = '0',
						specialinstructions = '',
						phoneno='',
						faxno='',
						fwddate= '0',
						contactname='Sachin',
						
						area='BA',
						estdeliverydays ='0',
						email='info@6sigma.academy',
						taxgroupid='1',
						defaultlocation='NADI',
						brpostaddr1 = '',
						brpostaddr2 = '',
						brpostaddr3 = '',
						brpostaddr4 = '',
						brpostaddr5 = '',
						disabletrans='0',
						defaultshipvia='1',
						custbranchcode='',
						deliverblind='1'
					WHERE branchcode = '1' AND debtorno='1'