Help for this page

Select Code to Download

Select or download this

my $insertMRNQuery = qq{
     insert #mrns (PAT_MRN_ID) 
     values (CAST(? AS VARCHAR)) };

Select or download this

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