Re: Help with select/between

>>>}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' >To Waard Kaatz >between isn't matches so what you get from your select is literally what is between >A* and AV* where the * is taken as any regular character. I only addressed the "AV*" not selecting the 'AVSA' record (thus the AW* or AVT*). I did not mean for my answer to be a perfect solution nor one that would address any more data than was provided in the question. I agree that it *could* return additional unwanted records. best regards, Ward Kaatz **************************************************************** Ward Kaatz FourGen Software, Inc. Senior Analyst - Tools Support Seattle, Wa (206)517-6507