You may want to strongly consider converting the data to a timestamp
field type, but that's for down the road.
You want to do you search like any other range search you would do.
select * from orderheadr where orderid between "2003012400" and
"2003012499"
You're saying you want to searc
Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Chuck Barnett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 24, 2003 6:33 PM
Subject: question about date range
> Hi, I inherited a db that has a varch
Hi, I inherited a db that has a varchar(30) column that holds a date/time
stamp in the form of MMDDHHmmss (ex: 20030124093952)
Well I want to select a range based on the first 8 characters(MMDD).
I currently select a single day by
select * from orderheader where orderid like '$date' ;
T
