<= (Less Than or Equal To) (SSIS)
Performs a comparison to determine if the first expression is less than or equal to the second one. The expression evaluator automatically converts many data types before it performs the comparison.
Note
This operator does not support comparisons that use the DT_TEXT, DT_NTEXT, or DT_IMAGE data types.
However, some data types require that the expression include an explicit cast before the expression can be evaluated successfully. For more information about legal casts between data types, see Cast (SSIS).
Note
There are no spaces between the two characters in this operator.
Syntax
expression1 <= expression2
Arguments
- expression1, expression2
Is any valid expression.
Result Types
DT_BOOL
Remarks
The expression set, expression1 and expression2, must follow one of these rules:
- Numeric. Both expression1 and expression2 must be a numeric data type. The intersection of the data types must be a numeric data type as specified in the rules about the implicit numeric conversions that the expression evaluator performs. The intersection of the two numeric data types cannot be null. For more information, see Data Type Conversion in Expressions.
- Character. Both expression1 and expression2 must evaluate to either a DT_STR or a DT_WSTR data type. The two expressions can evaluate to different string data types.
- Date. Both expression1 and expression2 must evaluate to one of the date data types: DT_DBDATE, DT_DATE, DT_DBTIME, DT_DBTIMESTAMP, or DT_FILETIME. The two expressions can evaluate to different date data types. Dates are converted to the DT_DBTIMESTAMP data type before they are compared.
String comparisons are case, accent, kana, and width-sensitive.
If either expression in the comparison is null, the comparison result is null. If both expressions are null, the result is null.
Examples
This example evaluates to TRUE if the current date is July 4, 2003 or later. For more information, see GETDATE (SSIS).
"7/4/2003" <= GETDATE()
This example evaluates to TRUE if the value in the ListPrice column is less than or equal to 500.
ListPrice <= 500
This example evaluates the variable LPrice and evaluates to TRUE if the value is less than or equal to 500. The data type of LPrice must be numeric in order for the expression to parse.
@LPrice <= 500
See Also
Reference
> (Greater Than) (SSIS)
< (Less Than) (SSIS)
>= (Greater Than or Equal To) (SSIS)
Concepts
Operator Precedence and Associativity