TY that worked I dont know why that was causing me such a problem. Now that I see the answer it was easy.

I figured out a way to do it. Thank you

Figured it out it was the first line in the select needed the AS SET @SELECT = 'Year(Startdate) as YearToDate'.

Thank You for your response Alvin it made me...

The @SELECTFINAL adds in more valid fields to the select from the case statements. They are all straight column names so I dont believe that is it.

not sure where to do that