That's exactly what we're doing by showing you the right way! Assuming this is homework, you should be challenging your instructor by delivering outstanding results.

Easy if you happen to have a pattern-based string splitter in your toolbox.

WITH SampleData (palindrome) AS

(

SELECT 'Madam I''m Adam'

UNION ALL SELECT 'ABC'

UNION ALL SELECT 'ABBA'

UNION ALL SELECT 'A man, a plan, a canal - Panama!'

UNION ALL SELECT 'Madam in Eden, I''m Adam'

UNION ALL SELECT 'Doc, note: I dissent. A fast never prevents a fatness. I diet on cod'

UNION ALL SELECT 'Never odd or even'

),

SplitStrings AS

(

SELECT palindrome

,RemovePuncuation=

(

SELECT Item + ''

FROM SampleData b

CROSS APPLY dbo.PatternSplitCM(palindrome, '[A-Za-z]')

WHERE a.palindrome = b.palindrome AND [Matched] = 1

ORDER BY ItemNumber

FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'

)

FROM SampleData a

)

SELECT palindrome

,IsPalindrome=CASE WHEN REVERSE(RemovePuncuation) = RemovePuncuation THEN 1 ELSE 0 END

FROM SplitStrings;

The PatternSplitCM FUNCTION can be found in the fourth link in my signature.