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 apostrophes) is > not followed the query fails. > > Is there a way to generalize my SELECT statement so value_1 and value_2 can > be numbers or characters? What happens if you enclose them in quotes no matter what? All parts of ASCII considered that should still work. If not then maybe a stored procedure, but I'm not as savy with stored procedures to give a definite answer on that. > Thanks > cw -- Chris White PHP Programmer / DB Monkey in training Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]