SQL = UPDATE LIR_BUT_SITE SET ROW_IDENTIFIER = '4' , M_CUSTOMER_ABBREV = 'IBHW' , M_SITE_KEY = 'R_LIR_BUT_SITE-' , RESP_CENTER = 'Global Custom Svcs GCSC' , M_SITE_NAME = 'MZ3481-CHILDREN'S HOSPITAL WALTHAM' #### for $idx (0..$#hdr) { if ($row[$idx] ne "") { if ($found ne "N") { $updstmt .= ", "; $insstmt .= ", "; $valstmt .= ", "; } $found = "Y"; $updstmt .= $hdr[$idx]." = '".$row[$idx]."' \r\n";