I was wondering if someone could lend me a hand.

I have quite a lengthy SQL query.

What i want to do is break down the a column which stores the date and order the results just by the year. part of the query is as follows:

```
SELECT CONVERT(CHAR(8), DateAdd(minute, -601, pay.Expiry), 10) 
       as DailyDate 
FROM table 
ORDER BY DailyDate

```

This gives me a 'DailyDate' outputted in the following format:

```
12-07-14

```

The year is the last 2 digits.

Is there a way i can sort results based on those 2 digits?

Any help would be great.

Cheers,