Thanks, Guys. This really isn't working for me.
The data I'm querying on is an insurance policy number, some start with letters, some not. Some end with letters, some not. I'm trying to find those that start with a letter and end with a number. Here are some results from a few tests I've run. This works, and only returns lines that begin with a letter; SELECT i_pol# FROM pri_ins WHERE i_pol# >= 'A%' This doesn't work, and returns nothing even though there are lines that end in a letter, in addition, a number in the place of 'Z' also fails. SELECT i_pol# FROM pri_ins WHERE i_pol# <= '%Z' Obviously BETWEEN won't work since RBase doesn't know how to match lines ending in letters. Am I going to have to resort to cursors, or worse yet, port this to a MS Sql DB?
