$name = q{%} . $name;

my $sql = <<"END"
SELECT
  SSN, RTRIM(LAST_NAME,' '),
  TO_CHAR(BIRTH_DATE,'YYYY'),
  STORE
FROM
  PYHADMIN.PY_EMP_SHADOW
where
      TO_CHAR(BIRTH_DATE,'YYYY') like '$year'
  and SSN like '%$ssn'
  and RTRIM(LAST_NAME,'  ') like upper('$name')
  and rownum <= 1
END
;
my $yi = $dbh->prepare($sql);
$yi->execute();
#--------Send the values from the query into variables
($SSNc, $LAST_NAMEc, $YEARc, $storenum) = $yi->fetchrow_array;