3 ms·COALESCE(LASTNAME, ''), how hard is that?by adrianlmm 13y agoCOALESCE(LASTNAME, ''), how hard is that?masklinn 13y agoThat's a nonsensical suggestion, the guy's name is the string "Null" which is munged by some intermediate system, if you're looking for Mr Null you don't want to get people with empty names back.adrianlmm 13y agoHaha I get it now.deleted 13y ago[deleted]