By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SourceData | SUBSTRING10_TRICK | STUFF_TRICK |
---|---|---|
00001A | 1A | 1A |
0000ABCDEFGHI00J000KLMNIOPQSR | ABCDEFGHI0 | ABCDEFGHI00J000KLMNIOPQSR |
00001A01A65463546354654006543606566565 | 1A01A65463 | 1A01A65463546354654006543606566565 |
null | null | null |
A | A | A |
0 | 0 | |
0A | A | A |
0000000000000000000 | 000000000 |