By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT DATALENGTH('a');
SELECT DATALENGTH('a ');
SELECT IIF('a' = 'a ', 'True', 'False');
SELECT IIF(DATALENGTH('a') = DATALENGTH('a '), 'True', 'False');
| (No column name) |
|---|
| 1 |
| (No column name) |
|---|
| 2 |
| (No column name) |
|---|
| True |
| (No column name) |
|---|
| False |