(yes I'm aware I can define a function and call that, I'm just grumpy.
I CAN DO THIS IN SQL FOR HEAVEN'S SAKE)