Steve Jones tries out a function:
I was trolling the docs and noticed the SIGN() function. I have never written this in production code, but it is an interesting function. This post looks at where I might use this and when the need arises.
I knew of the SIGN() function but have never used it before I think a simple CASE expression with an inequality predicate is more my speed.