my @range = ( $c .. $d );
my $rangesql = join( ', ', map { $dbh->quote($_) } @range );
my $sql = "SELECT type FROM dog WHERE number IN ( $rangesql )";