I'm looking through some old searches and came across this line. From all the documentation I've found, coalesce returns the first non-null field. In this case, what is the '0' representing? If randomField is null, does it just return a char 0? ... View more