public void Get_Between_Test()
{
var sql = "SELECT * FROM [dbo].[Employee] WHERE StartDate BETWEEN '1/21/2018' AND '1/21/2019'";
var minifier = new SqlMinifier();
var sqlWords = minifier.LoadWordArray(sql);
var castPosition = 8;
Assert.IsTrue(sqlWords[castPosition] == "BETWEEN");
var output = new List <string>();
minifier.GetBetween(sqlWords, startingPosition: ref castPosition, output: ref output);
Assert.AreEqual(output.Count, 4);
Assert.AreEqual(castPosition, 12);
var results = minifier.HandleCast(output.ToArray());
Assert.AreEqual(results, "BETWEEN '1/21/2018' AND '1/21/2019'");
}
