SQL to find the year (1 Viewer)

[Joy83]

Hello,
I have a field that contains the date in this format 201109 integer
Each row includes cost and that field
I want to build sql that gets me the the amounts by year?

 

[Velocity]

SELECT SUM(cost) as total_cost
FROM your_table
WHERE date LIKE '%2011%'

 

[ebs17]

SELECT
   your_Date \ 100 AS [year],
   SUM(cost) AS total_cost
FROM
   your_table
GROUP BY
   your_Date \ 100

 

[sonic8]

I have a field that contains the date in this format 201109 integer

You should explain the format.
Without further explanation, the year could be 2020, 2011, or 2009 to name just the most plausible.