The + is like concatenate() but not exactly because it can also do maths (addition). Because of this, it tries to do math on things and appears to be treating your “004” as an integer; since 004 = 4 as an integer, it drops the preceding zeroes. concat(), concatenate() and format() are great ways to get around this nuance.
1 Like