I'm pretty sure SQL ill not multiply chars '1' * '4' it demands at least one numeric type to decide for the result type.

Yes! Implicit convertion is evil.

Even worst when converting dates and using fancy collations and no US-en.