Re: question about date range

2003-01-28 Thread Brent Baisley
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

Re: question about date range

2003-01-25 Thread Stefan Hinz, iConnect \(Berlin\)
Chuck, > select * from orderheader where orderid like '$date' ; > The $date variable equals 20030124% Am I right to suppose your query doesn't work? Did you try something like: $sql = "select * from orderheader where orderid like '$date'"; print $sql; in your application? If have not enough i