You want to do you search like any other range search you would do.
select * from orderheadr where orderid between "20030124000000" and "20030124999999"
You're saying you want to search on a range, but you are coding your query like searching for a similarity.
On Friday, January 24, 2003, at 12:33 PM, Chuck Barnett wrote:
Hi, I inherited a db that has a varchar(30) column that holds a date/time
stamp in the form of YYYYMMDDHHmmss (ex: 20030124093952)
Well I want to select a range based on the first 8 characters(YYYYMMDD).
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php