I have a query like the following:
Select Item, StartDate,
Case when Right(lot, 1) in ('A', 'B', 'C') then 'Suffixed'
else '' end as ItemNote
This doesn't seem to like the "IN ('A', 'B', 'C')". What can I use other then writing a long "Or This" string.