T-SQL - GROUP BY with LIKE - is this possible?
- by fieldingmellish
Is there a way to include a LIKE expression in a GROUP BY query? For example:
SELECT Count(*)
from tblWhatever
GROUP BY column_x [LIKE %Fall-2009%]
column_x:
--------
BIOL-Fall_2009
HIST Fall_2009
BIOL Spring_2009
Result:
------
Fall_2009 2
Spring_2009 1
