using string in an IN clause

Question

    UPDATE assets a 
SET a.labor_c_start_dt = '2017-01-01',
a.labor_c_end_dt = '2017-12-31'

WHERE a.asset = IN(asset1,asset2,asset3)

I'm trying to get it to check for the asset name match it and then adjust the following fields. but for some reason, it will not function.

Please help?

Thanks

Answer 1

You need to enclose the strings into quotes, e.g.:

UPDATE assets a 
SET a.labor_c_start_dt = '2017-01-01',
a.labor_c_end_dt = '2017-12-31'
WHERE a.asset IN('asset1','asset2','asset3')