[Solved] SQl CASE Statement

by


— ok, Was a date format issue. i used a European Date Format(dd-mm-yyyy) in my query but the system i use takes USA date Format(mm-dd-yyyy) so my query failed.
**

  • Solution

**
Select Cast(Case
When EventDate <=’01/01/2016′ then ‘PreSeason’
When EventDate >=’12/31/2016′ then ‘PostSeason’
Else ‘Season’
End As Varchar(25)) as Season, EventName From tblEvent

Thanks for Support!!!!

solved SQl CASE Statement