I figured it out. None of the array syntax worked. So, I converted the data in the array into a comma delimited string and put double quotes at the beginning and end of the string and it worked. The double quotes are added by the sql and are apart of the string. I used this implementation because my process reads in about 70 plus email addresses from the data set I need. I load those email addresses into an array. Hard coding them would not be good because they might change. By selecting them from my final data set, I ensure I have the most up to date list. Thanks!!!
my $rd_string = join('',@rd_list);