There are many ways to give the right answer...

Your solution is returning me a star character (*)... A dimension musl be provided to the @result variable declaration: Declare @result VarChar(10)......

Declare @d smalldatetime

set @d = '1957/7/5'

Select DATEDIFF(yy, @d, GETDATE()) -

CASE WHEN

DATEPART(m, @d) < DATEPART(m, GETDATE())

OR (

DATEPART(m, @d) = DATEPART(m, GETDATE())

AND

DATEPART(d, @d) <= DATEPART(d, GETDATE())

) THEN 0 ELSE...