Post date: Apr 28, 2014 12:15:11 AM
"Find the largest palindrome number that is the product of two three digit numbers."
This is another easy one if you use the REVERSE function.
WITH Ten(i) AS
(
SELECT 0
UNION ALL
SELECT i + 1
FROM Ten
WHERE i < 9
),
Integers(i) AS
(
SELECT 100 * h.i + 10 * t.i + o.i
FROM Ten o
CROSS JOIN Ten t
CROSS JOIN Ten h
WHERE h.i >= 1
)
SELECT MAX(i1.i * i2.i)
FROM Integers i1
CROSS JOIN Integers i2
WHERE CONVERT(varchar(6),i1.i * i2.i) = REVERSE(CONVERT(varchar(6),i1.i * i2.i))