The between operator IS inclusive
I suspect you wrote a query like:
WHERE filmTitle BETWEEN 'P' AND 'T'
If that is corret then it is immediately clear why you did not get any films starting with a 'T'. The ordering is the same as in your dictionary, so a 'T' alone comes before (Is maller than) 'T' with anything after it.
To get all files starting with T using the between operator you would say fx:
WHERE filmTitle BETWEEN 'P' AND 'TZZZZZZZZZZ'
just add enough 'Z'-s to make sure there isnt an actual film with that many.
But the reasoning abowe does not apply to the other end of the betwen range 'P' alone should be the very first of the filmtitles starting with a 'P'.
Could it be that there simply were no films starting with p in your database ?
Inside a text string there is no such thing as numbers. just characters. '1' is not the number one, it is a sting containing the digit one. How characters are sorted is detemined by the alfabet used. each alfabet assign a character code to each of its digits. If you look at the alphabet at http://www.asciitable.com/
you will see that the digits from '0' to '9' have character codes from decimal 48 to decimal 57. letters have higher codes (from decimal 65) so they are 'higher' in the ordering.
WHERE filmTitle BETWEEN '0' AND '9ZZZZZZZZZZ'
should find all filmTitles starting with a number
You should also not that the character code for a capital 'A' (dec 65) is different from the character code for a lovercase 'a' (dec 97). There are a set of collate rules in your database that tells it whether they sould be compared as just 'a's (case independent) or as different characters (case dependent). Above I have assumed case independent collation, because that is the default in modern databases, but your administrator may well have changed it for some reason.
"good is better than bad case its nicer" - Mammy Yokum