title: How to create ordinal numbers (i.e. "1st" "2nd", etc.) in SQL Server
body: <p>I recently responded <a href="https://stackoverflow.com/questions/30163920/formatting-datetime-in-ssrs-expression">to this question</a> in the SSRS-2008 tag that required changing the day number in a date to the ordinal number (i.e. "1st", "2nd" instead of "1", "2"). The solution involved a VB.Net function. I'm curious how one would go about performing this task in SQL (t-sql and SQL Server in particular), or if there is some built in support. </p>
  
  <p>So here is a scenario: say you have organized a footrace for 1000 runners and have the results in a table with the columns Name and Place (in normal numbers). You want to create a query that will display a user's name and their place in ordinal numbers.</p>