The below mentioned query is search varchar, but I need integer query

Names aren't integer values: "Mohamed Mubarack" or "OriginalGriff" cannot be added together, multiplied, or divided!

So unless you want to use a numeric field (INT, FLOAT, or DECIMAL) you can't use an "integer query".
If you do use a numeric field, then it's trivial:

SELECT * FROM MyTable WHERE Quantity > 0

Or:

SELECT * FROM MyTable WHERE Quantity < 100 

Or perhaps:

SELECT * FROM MyTable WHERE Quantity BETWEEN 0 AND 100

Or even:

SELECT * FROM MyTable WHERE Quantity IN (1, 2, 3)