Is it possible to order by a substring in a returned field?<BR>I've got a query ... to group data rows together by year and then order that by semester. I can't think of how I'd do this in SQL ...