InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 04:24:35 GMT20http://www.sqlservercentral.com/Forums/Topic1426132-1292-1.aspxAt the moment you have it written like an IF Statement[code="sql"]CASE WHEN conditional_a = conditional_b THEN something ELSE conditional_a = conditional_c THEN something_else ELSE Default_SomethingEND [/code] With CASE statements you write them like this[code="sql"]CASE WHEN conditional_a = conditional_b THEN something WHEN conditional_a = conditional_c THEN something_else ELSE Default_SomethingEND[/code]Hope this helps.Mon, 04 Mar 2013 02:52:22 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1426132-1292-1.aspxDon't worry all sorted:Declare @DOB DatetimeDeclare @Today DatetimeSet @DOB = '01 November 1971'Set @Today = '01 November 2011'SELECTCASE WHEN DatePart(Month, @Today) < Datepart(Month,@DOB) THEN (Datediff(Year,@DOB,@Today) - 1) WHEN DatePart(Month, @Today) > Datepart(Month,@DOB) THEN Datediff(Year,@DOB,@Today) WHEN DatePart(Month, @Today) = Datepart(Month,@DOB) THEN CASE WHEN DatePart(Day, @Today) < Datepart(Day,@DOB) THEN (Datediff(Year,@DOB,@Today) - 1 ) WHEN DatePart(Day, @Today) >= Datepart(Day,@DOB) THEN (Datediff(Year,@DOB,@Today) ) END END AS How_Old_Am_IMon, 04 Mar 2013 02:49:53 GMTwafw1971http://www.sqlservercentral.com/Forums/Topic1426132-1292-1.aspxI have been asked to come up with a case statement that gives me the date of birth, no I know there are easier ways to do it but its about writing the actual statement which I have done but I have got a bit confused.Can you Help?Declare @DOB DatetimeDeclare @Today DatetimeSet @DOB = '01 November 1971'Set @Today = GETDATE()SELECT Datediff(Year,@DOB,@Today) AS Years, Datepart(Month,@DOB) As DOB_Month, Datepart(Day, @DOB) as DOB_Day,DatePart(Month, @Today) As Current_Month, Datepart(Day,@Today) AS Current_DayCASE WHEN DatePart(Month, @Today) < Datepart(Month,@DOB) THEN Datediff(Year,@DOB,@Today) THEN -1 ELSEDatePart(Month, @Today) = Datepart(Month,@DOB) THEN Datepart(Day,@Today) < Datepart(Day, @DOB) THEN Datediff(Year,@DOB,@Today) THEN -1 ELSE ENDMon, 04 Mar 2013 02:14:19 GMTwafw1971