CASE Statements

[Scooby62]

Hi there.

Does anyone know the syntax that allows for nested CASE Stmts?

 

[onpnt]

This time ok but please do some searching on your own next time. Now is you have a problem with a case in a query we're all for lending a hand

http://msdn2.microsoft.com/en-us/library/ms181765(SQL.90).aspx

_{____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[Scooby62]

Hey there.

I do appreciate your help but I'm creating a new field in an SQL query called EligDt (eligibility date). Basically if a person is of one status or another I want the case statement to alter their hire date. I'm working with more than one status, hence the need for a nested CASE statement.

 

[Ach005ki]

Hi Scooby - I was searching for some assistance with this too, and found the following thread with the first reply being a very helpful one from AlexCuse:

http://www.tek-tips.com/viewthread.cfm?qid=1343975

Mark, HH Associates