By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10000 rows affected
mode | id | replace_string | from_chars | to_chars | (No column name) |
---|---|---|---|---|---|
0 | 1 | abc[defghijklm[nop qr stuvw[]x][xyz[][z][]asd | a[]b cz | b][c-da | bcd]defghijklm]nop-qr-stuvw][x[]xya][]a[][bsd |
1 | 1 | abc[defghijklm[nop qr stuvw[]x][xyz[][z][]asd | a[]b cz | b][c-da | bcd]defghijklm]nop-qr-stuvw][x[]xya][]a[][bsd |
0 | 2 | abc[defghijklm[nop qr stuvw[]x][xyz[][z][]asd | a][b cz | b[]c-da | bcd]defghijklm]nop-qr-stuvw][x[]xya][]a[][bsd |
1 | 2 | abc[defghijklm[nop qr stuvw[]x][xyz[][z][]asd | a][b cz | b[]c-da | bcd]defghijklm]nop-qr-stuvw][x[]xya][]a[][bsd |
0 | 3 | abc[defghijklm[nop qr stuvw[]x][xyz[][z][]asd | abc z | bcd- | bcd[defghijklm[nop-qr-stuvw[]x][xy [][ ][]bsd |
1 | 3 | abc[defghijklm[nop qr stuvw[]x][xyz[][z][]asd | abc z | bcd- | bcd[defghijklm[nop-qr-stuvw[]x][xy [][ ][]bsd |
0 | 4 | abc\defghijk lmnop qrstuvw\x\xyz\[] | abc | bcd- | bcd\defghijk-lmnop-qrstuvw\x\xyz\[] |
1 | 4 | abc\defghijk lmnop qrstuvw\x\xyz\[] | abc | bcd- | bcd\defghijk-lmnop-qrstuvw\x\xyz\[] |
0 | 5 | abc | aabbcc | b-c-d- | bcd |
1 | 5 | abc | aabbcc | b-c-d- | bcd |
Msg 9828 Level 16 State 3 Line 1
The second and third arguments of the TRANSLATE built-in function must contain an equal number of characters.
id | replace_string | from_chars | to_chars | (No column name) |
---|---|---|---|---|
1 | abc[defghijklm[nop qr stuvw[]x][xyz[][z][]asd | xyz | ab | abc[defghijklm[nop qr stuvw[]a][ab[][][]asd |
Msg 9828 Level 16 State 3 Line 1
The second and third arguments of the TRANSLATE built-in function must contain an equal number of characters.
id | replace_string | from_chars | to_chars | (No column name) |
---|---|---|---|---|
1 | abc[defghijklm[nop qr stuvw[]x][xyz[][z][]asd | abc | abcd | abc[defghijklm[nop qr stuvw[]x][xyz[][z][]asd |