my $sql = 'SELECT COUNT(le_id) FROM legal_entity WHERE le_corid = ? AND le_lesid = ? AND le_inc_name = ?'; my $sth = $dbh->prepare($sql); $sth->execute(586,$lesid,$incname); my ($count_le) = $sth->fetchrow_array;