> All expressions generate column names on which I would never count.
> I always use an alias if I need to impose a name (and I always need).
> BTW, what should it return? Should it use "ZIP" as the column name?

Yes. If was going to call it something without my designating an
alias, ZIP is much more logical than substr.

Best regards