SQL User Defined Function

CREATE FUNCTION th (@Number as int)
RETURNS
varchar(255)
AS
BEGIN

--Prototyped by: John Naudus

declare @tempnumber as int
declare @ending as varchar(2)

if right(@number,2) < 14
    begin
        select @tempnumber = right(@number,2)
    end
else
    begin
        select @tempnumber = right(@number,1)
    end

SELECT     @ending = CASE
    WHEN @tempnumber = 1 THEN 'ST'
    WHEN @tempnumber = 2 THEN 'ND'
    WHEN @tempnumber = 3 THEN 'RD'
    ELSE 'TH'
    END

if @number < 1
    begin
        set @ending = ''
    end

return (CAST(@Number as varchar) + @ending)

END