Apparently not in database land. In Oracle, the empty string is actually NULL. Some versions of SQL also treat that string differently. If the programs that processed this person’s name stayed inside their executables, it probably would behave as you say, since strings are just another kind of variable. But once the string gets passed to a database, all bets are off.
NULL is not a string in SQL Server.