Good question and awesome answer by experts.. we should not use between operator in string comparision.. if we then should know the limitation that it will not consider last character string because it could start VA,VB like that and it will be greater than V

i think between is perfect for date data type