Then that is all that needed saying. You chose to make the bald statement "This explanation is wrong." - and then ramble on for pages, dodging and weaving, back-tracking, and wriggling to turn it into "incomplete". Laughable.

Sknox put it better in the post previous to your first one, "This explanation feels a little light. For completeness, it should include the behavior of the LEFT() function as well."

I don't know what you think your input added to that.

I have tried to be fair and extract the salient points from your verbose replies. Not my fault if you can't express yourself clearly.

For the record, I haven't changed my position one iota.