Case Syntax

So on the statement below I what it to get the IX.Amount when it's in any of those IX.XActType's as you can see. There may or may not be a transaction for any on these a,b,c,d,f,j,m,n,o,q,s,t,u,v,w,x,y,z,h,g types. If there are multiple which is possible I want to get the on that has the most recent IX.XactDate. Would I do that by putting in a max(IX.XactDate) somehow? Or is there a different way to do this?

Thanks

Code Snippet:

         
             case when IX.XActType in ('a,b,c,d,f,j,m,n,o,q,r,s,t,u,v,w,x,y,z,h,g') then IX.Amount
    else ' ' end as LastAdjustment,

Open in New Window

Select All

Solution: Case Syntax

case when IX.XActType in ('a', 'b', 'c', ) then IX.Amount
else ' ' end as LastAdjustment,

You could also try:

case when IX.XActType NOT LIKE '[eiklp]' then IX.Amount
else ' ' end as LastAdjustment,

or

case when IX.XActType NOT in ('e','i','k','l','p') then IX.Amount
else ' ' end as LastAdjustment,