@FemmeSTEMGem, your variant should not work, because

The TRUNCATE() function returns n truncated to d decimal places

So your solution returns X.X, but we need to get just X

Every thing that is hard coded or using simple functions should be faster

bool checks it first. If it's false, the second part of the expression (the one after and) is never evaluated.

Just answered you in another comment. Please use a spoiler flag when you post code, the comments are visible to everyone by default.

• ✔ Reuses and repurposes existing code
• ✔ O(1) solution
• ✔ Generates lots of user engagement - see all the comments below.
• ✔ Encourages users to scroll down the page (promotes physical activity, good cardio workout)

If you think about it, this really is the Best Practice.

See explanation a few comments below (reply to losttheplot12)

No, it's not. In fact, over a high number of invocations of the function, it probably actually be slower (allocation + hashing + lookup vs string comparison) The point of this isn't performance, it's convenience.