Reports

 select  Name ,CASE 
WHEN Place  = 1  then   concat(CAST(Place AS VARCHAR(10)),'st')
WHEN Place  = 2  then   concat(CAST(Place AS VARCHAR(10)),'nd')
WHEN Place  = 3  then   concat(CAST(Place AS VARCHAR(10)),'rd')
WHEN Place  in( 11, 12, 13)  then   concat(CAST(Place AS VARCHAR(10)),'th')
WHEN REMAINDER(Place,10) = 1 THEN concat(CAST(Place AS VARCHAR(10)),'st')
WHEN REMAINDER(Place,10) = 2 THEN concat(CAST(Place AS VARCHAR(10)),'nd')
WHEN REMAINDER(Place,10) = 3 THEN concat(CAST(Place AS VARCHAR(10)),'rd')
else concat(CAST(Place AS VARCHAR(10)),'th')
 end as Place
    
    from FootRaceResults
79819828
