Re: GROUP BY a computed column

CREATE TABLE Phrases
(phrase_id INTEGER NOT NULL PRIMARY KEY,
 phrase_txt VARCHAR(500) NOT NULL);

SELECT start_word, COUNT(*) AS start_word_cnt
  FROM (SELECT phrase_id, SUBSTRING (phrase_txt, 1, CHARINDEX(' ',
phrase_txt) - 1)
          FROM Phrases)
       AS FirstWords (phrase_id, start_word)
 GROUP BY start_word;