UPDATE empbasic_employee SET em_sname = 'Basharat Ali  Naz',em_sfirstname = 'Basharat Ali ',em_slastName = 'Naz',em_sfather = 'Rehmat Ali Chohan',em_datebirth = '04/14/1968 12:00:00 AM',em_datejoin = '06/13/1993 12:00:00 AM',em_dateeobijoin = '01/06/2003 12:00:00 AM',em_date_sessi_join = NULL,em_datejoin_new = '06/13/1993 12:00:00 AM',em_dateappoint = '06/13/1993 12:00:00 AM',em_ssex = 'SX001',em_imarital_status = 'MS001',em_sreligion = 'REL00001',em_spresentAddress = 'E-79/B Shoukat Town, Ghazi Raod, Lahore Cantt.',em_saddress = 'E-79/B Shoukat Town, Ghazi Raod, Lahore Cantt.',em_semergency_contact = '042-35802493',em_sspouse_phone = '0300-4526786',em_semail = 'banaz@wwf.org.pk',em_sidcard = '35201-6098569-7',em_seobi = NULL,em_snewntn = '2029575-0',em_ssocial_security = NULL,em_smedical_number = NULL,em_smailingAddress = 'E-79/B Shoukat Town, Ghazi Raod, Lahore Cantt.',em_sempcity = 'ACY00002',em_sleave_group = '004',em_saccess_group = 'AC001',em_imailingAddress = '0',em_scontactmobile = '042-35802493',em_igrant_eobi = '1',em_igrant_group_insurance = '0',em_igrant_ss = '1',em_sntn = '000010004',em_iprobation_period = '1',em_foreign_bank_acc_no = '0018795554501',em_sbank_account = '0018795554501',em_sbank_branch = 'BR001002',em_imultibank = '0',em_slocation = NULL,em_igrant_gratuity = NULL,em_special_code = NULL,em_spicture = NULL,em_sstatus = NULL,em_sresidenceno = NULL,em_dateresign = NULL,em_snationality1 = 'ACU00001' Where em_semployee = '10004'