Re: Help with select/between

>> The user wants to wildcard select to get different variations of >> data. If they enter in A*-AV* they expect to get the first 5 items >> on the list. you have mistakenly assumed that the between operator accepts wildcard characters. however you can obtain the same results by changing: select <field_name> from <table> where <field_name> between "A*" and "AV*" to: select ... between "A" and "AV~" as "~" is the last printable ascii character.