Re: help with SELECT BETWEEN

--- Chris <[EMAIL PROTECTED]> wrote: > I want to create a SELECT statement using BETWEEN like: > SELECT * FROM mytable WHERE myfield BETWEEN value_1 AND value_2. The > field > I'm applying my BETWEEN clause is a varchar. > > Now, if value_1 and value_2 are numbers the select statement works a

Re: help with SELECT BETWEEN

On Tuesday 25 April 2006 09:33 am, Chris wrote: > I want to create a SELECT statement using BETWEEN like: > SELECT * FROM mytable WHERE myfield BETWEEN value_1 AND value_2. The field > I'm applying my BETWEEN clause is a varchar. > If the appropriate format (enclosing or not enclosing with apostr

help with SELECT BETWEEN

I want to create a SELECT statement using BETWEEN like: SELECT * FROM mytable WHERE myfield BETWEEN value_1 AND value_2. The field I'm applying my BETWEEN clause is a varchar. Now, if value_1 and value_2 are numbers the select statement works as is. If value_1 and value_2 are characters I need