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
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