Re: Help with select/between

At 02:31 9.22.95 GMT, Tammy Croteau wrote: }In a table I have the following data: }AGCR }AGST }ALAR }ANGE }AVSA }AXXA }BRAM } }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. } }My sql statement is as follows: }select <field_name> from <table> where <field_name> between "A*" and "AV*" AVSA is not *between* "A*" and "AV*' --> 'AVT*' or 'AW*' would pick up 'AVSA' **************************************************************** Ward Kaatz FourGen Software, Inc. Senior Analyst - Tools Support Seattle, Wa (206)517-6507