By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT 19 = '19c5bx'
| 19 = '19c5bx' |
|---|
| 1 |
SELECT CAST(19 AS CHAR) = '19c5bx'
| CAST(19 AS CHAR) = '19c5bx' |
|---|
| 0 |
SELECT CAST(19 AS CHAR) = '19'
| CAST(19 AS CHAR) = '19' |
|---|
| 1 |
SELECT CAST(19 AS CHAR) = 19
| CAST(19 AS CHAR) = 19 |
|---|
| 1 |