I want to delete top 100 records in a table where a certain condition is true
My sql looks like:

Delete TOP 100 * From db..tablename Where cond1 = @var1 AND Convert(Char(8), Date_Time, 112) = @var2

In Query Analyzer this gives me an error at 'TOP', why?

Thanks