DELETE Syntax

[JoseSilva]

Hi

Can somebody help me here:

I have quite a number of rows between a ceta row and another row in my DB that I want to delet.

I tried:

DELETE FROM table WHERE "col1" >= '40000' AND "col1" =<50000
It gives me a syntax error.
Thanks


Jose Silva

[Nedals]

DELETE FROM table WHERE col1 BETWEEN 40000 AND 50000