I'm looking for the best way to select records all records from a table where the value is W and then set that field to be P
You can use the Program Commandshape for this, configuring it with the database connection and an SQL statement like:
UPDATE <tablename> SET <fieldname> = 'P' WHERE <fieldname> = 'W'.
Another possibility would be to use a Database connector GET action, setting the value of the field to 'P' in a map, then using a Database connector SEND action.
Retrieving data ...