Best practice : converting INT to VARCHAR

Good points, thanks.

Do you CONVERT, CAST, STR() ... or something else? Any reason why you do ti that way - e.g. some considered opinion for it being more Defensive Programming or avoiding some GotCha?