SELECT   LEN('Hello') AS [0 trailing spaces],
         LEN('Hello ') AS [1 trailing spaces],
         LEN('Hello  ') AS [2 trailing spaces],
         LEN('Hello   ') AS [3 trailing spaces],
         LEN('Hello    ') AS [4 trailing spaces],
         LEN('Hello          ') AS [10 trailing spaces]
;


SELECT   CASE
              WHEN 'Hello' = 'Hello    ' THEN 'EQUAL'
              ELSE 'NOT EQUAL'
         END
;

SELECT   6.0/2.0*3.0,
         6.0/-2.0*3.0
;

SELECT   CAST('' AS INT) AS [INT],
         CAST('' AS BIGINT) AS [BIGINT],
         CAST('' AS FLOAT) AS [FLOAT]
;

SELECT   CAST('' AS DECIMAL(15,6)) AS [DECIMAL],
         CAST('' AS NUMERIC(15,6)) AS [NUMERIC]
;

SELECT   *
FROM     EXAMPLE_TABLE
WHERE    COL1 = 5
         OR COL1 <> 5
;


SELECT   *
FROM     EXAMPLE_TABLE
WHERE    COL1 = 5
         OR NOT(COL1 = 5)
;

SELECT   *
FROM     EXAMPLE_TABLE
WHERE    COL1 NOT IN (1, 2, 3, 4, 5, NULL)
;



SELECT   *
FROM     EXAMPLE_TABLE
WHERE    1 = 1
;



SELECT   *
FROM     EXAMPLE_TABLE
WHERE    NULL = NULL
;

SELECT   CAST(0.0000006 AS DECIMAL(38,22)) * CAST(1.000000 AS DECIMAL(38,22))
;