Is this kind of SQL DELETE statement valid?

[VAer]

The code is just an example. Is it okay to have same values in BETWEEN...AND statement? You may wonder why I do not write it as Price = 10, because I would like to replace the two numbers with two textbox input values(the code is behind the scene, and user will not see it), let us say there are two input textbox, LowerLimit and UpperLimit. If user enters 5 as LowerLimit and enters 13 as UpperLimit, then BETWEEN 5 AND 13 statement works fine. If user enters 8 as LowerLimit and enters 8 as UpperLimit, I wish the statement Price BETWEEN 8 AND 8 acting same as Price = 8

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 10;

[Micron]

Use >= AND <= if you're using integers. Logically, 8 is not between 8 and 8.

[CJ_London]

between 8 and 8 will work. But why are you asking the question? it is simple enough for you to run the code you provided

[Missinglinq]

"Is this kind of SQL DELETE statement valid?"

Not to be picky, but what Delete Statement?

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 10;