Is this a viable SQL statement: DELETE FROM [table1] WHERE [col1] < 100; This should delete all rows in column 1 less than 100. ...