SELECT column_name(s) FROM table_nameWHERE column_name BETWEEN value1 AND value2 SELECT * FROM COILS WHERE COIL_NAME BETWEEN SomeValue1 AND SomeValue2 Between operator is like It will select a row where COIL_NAME has SomeValue1 . Value depends on database to database . Some database will select rows where COIL_NAME has SomeValue1 and where COIL_NAME...