Data 1, 2, 3, 4, 11, 21, 99
I want to get 1st, 2nd, 3rd, 11th, 21st, and 99th
I could roll my own, but is there any function built into SQL server that could so this for me? Corollary: I will also be looking for a function to turn numbers into words, as in:
72,451 -> seventy-two thousand, four hundred fifty-one
And would expect it (if it exists) to be in the same family of formatting methods.