SQL How would you use the Between command in SQL langauge

SELECT * FROM Table WHERE Column BETWEEN number1 AND number2;