Tim Lerner's T-SQL solution to GPCv1 Level 1

v1_level1_tsql.sql

declare @String varchar(8000) = 'Fourscoreand...'
select l.N as TestLen
        , c.N as TestChar
        , substring(s.String, c.N, l.N) as Candidate
from (select @String as String) s
        cross join master.dbo.Tally l
        cross join master.dbo.Tally c
where 1 = 1
        and l.N > 1
        and l.N <= len(s.String)
        and c.N <= len(s.String)
        and c.N + l.N < len(s.String)
        and substring(s.String, c.N, l.N) = reverse(substring(s.String, c.N, l.N))
order by l.N desc, c.N desc
go