Use brackets to enclose a range of characters, such as [a-f], or a set of characters such as [a2Br]. When ranges are used, all values in the sort order between (and including) rangespec1 and rangespec2 are returned. For example, “[0-z” matches 0-9, A-Z and a-z (and several punctuation characters) in 7-bit ASCII.
To find names ending with “inger” and beginning with any single character between M and Z:
select au_lname from authors where au_lname like "[M-Z]inger"
To find both “DeFrance” and “deFrance”:
select au_lname from authors where au_lname like "[dD]eFrance"