Stack Exchange
log in help

Question titles by last non-punctuation character

0

Please login or register to vote for this query.

(click on this box to dismiss)

Experimenting around http://meta.japanese.stackexchange.com/questions/566/question-is-inacessible-due-to-invalid-utf-8-character-in-a-title http://meta.japanese.stackexchange.com/questions/899/redirect-problem-for-a-specific-question http://meta.stackexchange.com/questions/233850/redirect-loop-after-editing-a-question-title-ending-with-no-break-space-questio

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  Min(Id) AS [Post Link],
  Left(Right(Title, PatIndex('[^?.]', Reverse(Title)) + 1), 1) AS [Character]
FROM Posts
WHERE PostTypeId = 1
GROUP BY Left(Right(Title, PatIndex('[^?.]', Reverse(Title)) + 1), 1)
ORDER BY [Character] ASC
fork query

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results