Query to remove spaces in data

Question

Hello,

In Access I have table and in the table I have a "Short Text" column.

Below is an example of data in the column but I need to run an update query to remove any spaces before, within and after the data.

Could you help me create an update query to do this?

cf4872ab

cf4872wg

cf6259nx

CF4089sK

CF 4380 AW

CF 4380 PW

Answer 1

UPDATE [TableName] SET [FieldName]=Replace([FieldName]," ","")

Answer 2

UPDATE YourTable SET YourField = Replace(YourField, " ", ""}