SELECT
        'Week Of ' + CONVERT(VARCHAR(2), DATEPART(DAY, GETDATE())) + CASE
                                                                      WHEN DATEPART(DAY, GETDATE()) % 100 IN (11,12,13) THEN 'th' --first checks for exception
                                                                      WHEN DATEPART(DAY, GETDATE()) % 10 = 1 THEN 'st'
                                                                      WHEN DATEPART(DAY, GETDATE()) % 10 = 2 THEN 'nd'
                                                                      WHEN DATEPART(DAY, GETDATE()) % 10 = 3 THEN 'rd'
                                                                      ELSE 'th' --works for num % 10 IN (4,5,6,7,8,9,0)
                                                                    END