Online Documentation for SQL Query for SQL Server

Setting filter criteria values


Next, we need to specify value '10/1/2007' for the IS GREATER THAN operator.

 

Similarly, if, for example, we need to get the list of employees hired during the 9/1/2007 - 10/1/2007 term, we set the BETWEEN filter operator (this will add two empty value boxes to specify the inclusive range for the BETWEEN condition) and specify the range for the operator, i.e. the '9/1/2007' and the '10/1/2007' values in the corresponding value boxes.

 

It is possible to set the date value manually by typing it in, or via the date editor which is activated when you click the value box.

 

Filter Builder dialog - Setting filter criteria values

 

Editors used in value boxes are determined by the data type assigned to the corresponding columns.