Re: Help with select/between

In article <441ek8$r7s@cssun.mathcs.emory.edu>, Ward Kaatz <wardk@fourgen.com> wrote: >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' > What about this sql statement? select <field> from <table> where <field> matches "A*" union select <field> from <table> where <field> matches "AV*" John -- - J -