my $insertMRNQuery = qq{
     insert #mrns (PAT_MRN_ID) 
     values (RIGHT(STRING('0000000000',?),10)) };