Ok, the following will give me the results from a SELECT (see attached)
SELECT FORMAT(CONVERT(datetime, StartDate), 'yyyyMMdd') AS StartDate FROM [MercerReportTableMod]
BUT I NEED TO ACTUALLY UPDATE this field (column) in the Table to have the same results
I have tried the following but it does nothing
SET StartDate = FORMAT(CONVERT(datetime, StartDate), 'yyyyMMdd')
PLEASE, how can I actually update the data in the column (the SELECT above works perfectly but of course doesn't update the data)...