Collections:
BETWEEN - Testing Value in a Range in SQL Server
What To Test Value Ranges with the BETWEEN Operator in SQL Server Transact-SQL?
✍: FYIcenter.com
Sometimes you want to compare a value against a value range. You can do this with two regular comparison operations. But you can also use the special comparison operator BETWEEN to get it done with the following syntaxes:
1. Inclusively in the range test test_value BETWEEN range_start_value AND range_end_value - Returns the same results as the following expression test_value >= range_start_value AND test_value <= range_end_value 2. Exclusively out of the range test test_value NOT BETWEEN range_start_value AND range_end_value - Returns the same results as the following expression test_value < range_start_value OR test_value > range_end_value
Here are two examples of using the BETWEEN operator:
DECLARE @my_age INT; SET @my_age = 17; SELECT CASE WHEN @my_age BETWEEN 11 AND 19 THEN 'You are a teenager.' ELSE 'You are not a teenager.' END; GO You are a teenager. DECLARE @my_age INT; SET @my_age = 27; SELECT CASE WHEN @my_age NOT BETWEEN 11 AND 19 THEN 'You are not a teenager.' ELSE 'You are a teenager.' END; GO You are not a teenager.
⇒ IN - Testing Value in a Value List in SQL Server
⇐ Performing Comparison on Character Strings in SQL Server
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-21, 1440🔥, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...