Converting string yyyy-QQ to YYYY

[Anonymous]

I have values in a table 2016-Q1,2016-Q2,2016-Q3,2016-Q4 and its associated counts.I would like to convert this as YYYY to get the counts for total year.Could anybody suggest the way to achive it.I have tried min string  but not successful

[oknotsen · Accepted solution]

Try this:

left(fieldname, 4) as fieldName