just realised...ill repost (or can it be moved?)

time datatypes confirmed

im using sql server 2008 that came bundled with the visual web developer express edition.

i have pulled the data out of open office (via excel) it's clean &...

ok the statement reads:

CASE WHEN dbo.Races.rSealed = 0 THEN (dbo.Results.rTime - dbo.Results.rHandicap) ELSE (dbo.Results.rTime + dbo.Results.rHandicap)

...