Determines
whether the given value is within a given range.
Parameters
Parameter
|
Description
|
s1
|
The value to test for.
If s1 is
a number, the ordering comparison is numeric.
If s1 is
not a number, the ordering comparison uses the collating sequence
for the current locale.
For more information, see Locales.
If s1 is
null, the function returns null.
|
s2
|
The lower bound of the test range.
|
s3
|
The upper bound of the test range.
|
ExamplesThe
following expressions are examples that use the Within function:
Expression
|
Returns
|
Within("C", "A", "D")
|
True (1)
|
Within(1.5, 0, 2)
|
True (1)
|
Within(-1, 0, 2)
|
False (0)
|
Within($, 1, 10)
|
True (1) if the current
value is between 1 and 10.
|
|
|
|