The column "title" exists in a normal query.
Need to select the first letter of the titles to build a list for a prev-next alphabetical search.
I am not able to make this QoQ work.
I have tried many variations both in the SELECT statement and in the GROUP BY
SELECT left(getEntries.Title,1) as FirstLetter
GROUP BY left(getEntries.Title,1)
Any help cordially appreciated. Thank You