addition
x
4 ← 2 + 2Arithmetic Operators
Bitwise Operators
Comparison Operators
- z = z
- z > z
- z < z
- z >= z
- z <= z
- z <> z
- z != z
- z !< z
- z !> z
equality test
b
4 = 2 + 2
'a' = 'A'greater than
b
55 > 44
'time' > 'money'less than
b
44 < 55
'angst' < 'courage'greater than or equals
b
55 >= 55
'passion' >= 'persistence'less than or equals
b
44 <= 55
'manqué' <= 'munificent'not equal
b
44 <> 55
'yin' <> 'yang'not equal
b
not less than
b
not greater than
b
Compound operators
Logical Operators
- z { = | <> | > | >= | < | <= } ALL( subquery )
- b AND b
- b OR b
- z { = | <> | > | >= | < | <= } ANY( subquery )
- z [ NOT ] BETWEEN z AND z
- z [ NOT ] IN ( subquery | z [,...z] )
- z [ NOT ] LIKE pattern [ ESCAPE espacechar ]
- NOT b
- z { = | <> | > | >= | < | <= } SOME( subquery )
evaluate all to true for true
b
logical AND
b
'True' ← SELECT CASE
WHEN 1 = 1 AND 2 = 2
THEN 'True'
ELSE 'False'
END
'False' ← SELECT CASE
WHEN 1 = 1 AND 2 = 4
THEN 'True'
ELSE 'False'
ENDlogical OR
b
'True' ← SELECT CASE
WHEN 1 = 1 OR 2 = 2
THEN 'True'
ELSE 'False'
END
'True' ← SELECT CASE
WHEN 1 = 1 OR 2 = 4
THEN 'True'
ELSE 'False'
ENDevaluate any to true for true (identical to SOME)
b
range test
b
match test
b
pattern test
b
logical NOT
b
'False' ← SELECT CASE
WHEN NOT 1 = 1
THEN 'True'
ELSE 'False'
END
'True' ← SELECT CASE
WHEN NOT 2 = 4
THEN 'True'
ELSE 'False'
ENDevaluate any to true for true (identical to ANY)
b
Unary Operators
- + x
- - x
- ~ n
positive
x
5 ← +5negative
x
-5 ← -5bitwise complement
n
1 ← ~ CAST(0 AS BIT)
0 ← ~ CAST(1 AS BIT)
255 ← ~ CAST(0 AS TINYINT)
(11111111 = ~00000000)
254 ← ~ CAST(1 AS TINYINT)
(11111110 = ~00000001)
240 ← ~ CAST(15 AS TINYINT)
(11110000 = ~00001111)
-1 ← ~ CAST(0 AS INT)
(11111111 = ~00000000)
-2 ← ~ CAST(1 AS INT)
(11111110 = ~00000001)
-16 ← ~ CAST(15 AS INT)
(11110000 = ~00001111)