@PeterVandivier I agree with your conclusion, but I think SpringLearner's issue is with MySQL rather than SQL Server. My guess is that SQL Server was only mentioned for comparison, to illustrate that the string conversion issue (which, it now seems, is the Y of the question's
XY formula) doesn't happen in SQL Server.