Help Plz: Sql statement

From: Jim <jim_kangosjarvi_at_hotmail.com>
Date: 17 Mar 2003 05:41:08 -0800
Message-ID: <b2464361.0303170541.4126ddba@posting.google.com>

I want to create a sql query that receives data from a table that looks like this

Action xxxxx
StartDate yymmdd
StartTime hhmm
EndDate yymmdd
EndTime hhmm

Ex. what it can contain
X1
031201
0900
031201
1000

X2
031202
0300
031202
0400

X2
031303
1100
031203
1200

select * from table where (StartDate >= 031201 and StartTime >= 0600) and (EndDate <= 031203 and EndTime =< 0600

Sql statement should give all rows
but X2 wont be given back because StartTime fails, but it should because the action is done day between start date and end date.

How should this sql look like?

Regards Jim Received on Mon Mar 17 2003 - 07:41:08 CST