I imported data from Excel tables into SQL and a lot of fields had white spaces at their beginnings and ends.

I tried

```
update Table_Names set Name_ID = replace(Name_ID, ' ', '')

```

and

```
update Table_Names set Name_ID = LTRIM(Name_ID)

```

and

```
Update TableName set Name_ID = LTRIM(RTRIM(Name_ID))

```

Each one of those returned the number of rows affected. But then when I selected the fields again, they still had white spaces at the beginning and end.

Any idea why this is happening and how to solve it?

Any help would be appreciated