Selecting a different col based upon another col

[megwich]

Hi
I have a table that has the following cols

RouteID,TimeDepart,TimeArrival
for example a row may have
1020,700,-1
i.e. RouteID = 1020, timedepart = 700, TimeArrival = -1
most rows conform to a timedepart having a positive value and the timearrival being -1 (effectively stating that the route arrives and departs at the same time)
the odd row, though has

RouteID = 1021, Timedepart = -1, TimeArrival = 900


I would like to select all rows that have a positive number(either Timedepart or TimeArrival), this will give me a count of how many routes have a time allocated to them. is there a sql statement that will allow me to get a count based upon either col having a positive number


Thank you for your help

 

[r937]

select count(*) from yourtable
where Timedepart > 0 or TimeArrival > 0

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)