--- Ron St-Pierre <[EMAIL PROTECTED]> wrote: > I'm sure that others have solved this but I can't find anything with my > (google and archive) searches. I need to retrieve data where the text > field is within a certain range e.g. > A-An > Am-Bc > Bc-Eg > .... > Yi-Zz > > Does anyone know of a good approach to achieve this? Should I be looking > into regular expressions, or maybe converting them to their ascii value > first?
Regular expressions would work, but a between statement should work also. SELECT * FROM Your_table AS YT WHERE YT.text_field BETWEEN 'Aa' AND 'An'; ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
