Yeah, but that leads to huge query strings if the numbers differ a lot. I'd write it as:

    SELECT type
    FROM   dog
    WHERE  number >= 2 AND number <= 8
[download]

using placeholders for the two values.