clear markdown compare help donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 497219 fiddles created (9447 in the last week).

create table Players ( PlayerID int, Name text ) ;
 hidden batch(es)


INSERT INTO Players (PlayerID, Name) VALUES (1, '"Mark ' || CHAR(10) || '"') ;
 hidden batch(es)


SELECT PlayerID, Name, REPLACE(Name, CHAR(10), '') AS NewName_NoLinefeed, REPLACE(Name, ' ', '') AS NewName_NoSpace, REPLACE(REPLACE(Name, CHAR(10), ''), ' ', '') AS NewName_NoLinefeed_NoSpace FROM Players -- WHERE PlayerID <= 500 ;
PlayerID Name NewName_NoLinefeed NewName_NoSpace NewName_NoLinefeed_NoSpace
1 "Mark " "Mark " "Mark " "Mark"
 hidden batch(es)


UPDATE Players SET Name = REPLACE(Name,CHAR(10),'') WHERE PlayerID <= 500 ;
 hidden batch(es)


SELECT * FROM PLayers ;
PlayerID Name
1 "Mark "
 hidden batch(es)


UPDATE Players SET Name = REPLACE(Name, ' ', '') WHERE PlayerID <= 500 ;
 hidden batch(es)


SELECT * FROM PLayers ;
PlayerID Name
1 "Mark"
 hidden batch(es)