Showing posts with label SQL. Show all posts
Microsoft SQL Server Function to Get Ordinal Suffix of a Number
This AddOrdinal function will be useful when we needed to display the date format as 1st July -3rd October. There is nothing in there about ordinals, but it can't be done using String.Format. However it's not really that hard to write a function to.