I would like to know how to make an SQL search to span 2 letters, this is what I have so far, but it only search litterally BETWEEN the letters, so 'a%' AND 'f%', only returns b%, c%, d% and e%... How can I change the string to allow the letters a AND f?

Select Case arrsearch(1)
    Case "a_f"
    query = "SELECT * FROM Recipe WHERE R_name BETWEEN 'a%' AND 'f%'"
    Case "g_l"
     query = "SELECT * FROM Recipe WHERE R_name BETWEEN 'g%' AND 'l%'"
    Case "m_r"
     query = "SELECT * FROM Recipe WHERE R_name BETWEEN 'm%' AND 'r%'"
    Case "s_z"
     query = "SELECT * FROM Recipe WHERE R_name BETWEEN 's%' AND 'z%'"

Since your queries are literal strings. You might this awkward construct (remember you're comparing literal 2 character strings alphabetically... probably not the most elegant solution):

Case "a_f"
    query = "SELECT * FROM Recipe WHERE R_name>='aa' AND R_name<='fz'"
Case "g_l"
    query = "SELECT * FROM Recipe WHERE R_name>='ga' AND R_name<='lz'"

Or something like this:

query = "SELECT * FROM Recipe WHERE (R_name LIKE 'a%') OR (R_name LIK 'b%') OR (R_name LIKE 'c%') OR (R_name LIKE 'd%') OR (R_name LIKE 'e%') OR (R_name LIKE 'f%')"

I'm intrigued by what you say, you say that how I did it is not elegant? How, if I may, would you have done it instead? Always interested in refining code

Why not use > and < instead of between ?

Case "a_f"
    query = "SELECT * FROM Recipe WHERE (R_Name>'A%' And R_Name<'F%')

??

What I meant is that my solution is not the most elegant, but it does work.

Whereas in the comparison below, the % character is taken literally

And since '%' comes before 'A', 'FA' or 'FB' would never be included in the result set.