Where Techniques

Clause	Condition Expression	Example
where	simple-condition	For a simple filter condition, see Load Data with <directinvoke> and Filter Rows.
	complex-condition	To use multiple conditions, arithmetic or logical operators, see Where Complex Conditions.
	column-namelike text-pattern	To use text matching, see Where Text Like Patterns.
	column-namein (value1, value2[,...])	To match to an enumerated set of values, see Where in Sets.
	column-namebetween range-startand range-end	To match within a range of values.
	dynamic condition	To provide dynamic values to filter conditions, see Parameters in Where Clauses.
	function(column-name) in condition	To use functions on column values in filters, see Plain Functions in Where.