Okay, I'll try that. Thank you so much.

Yes, it is a date field. It is the month posted so the day is always the first, but the month and year change.

Sorry bout that.

Select 

p.scode as PropID,

t.umonth,

'A' as Activity,

Case when a.scode IN ('14901000','14902000','14904000','14905000','14906000') then '2000'

when a.scode IN ('15101000','15102000','15104000','15105000','15106000','15109000') then '4000'

when a.scode IN ('15301000','15305000','15306000','15401000','15404000') then '1000' else null end as ADS_Life,

Case...