Update All data in a table

[Dydom]

Hi,
I need to update all data of my table.
I want to put all characters in capital letters, so I want to know if I can use a function like Ucase in SQL.
And of couse, how can I update all fields at the same time.
And I also need to replace all special characters present in this database.
So, i tried to use command like :
UPDATE nom_table SET nom_champ = '%E%' WHERE nom_champ = '%é%' ;
Of course, i made a loop to select all fields.
But, the update don't work, characters are nor replace.
Thanks for any help
Dom

 

[AWithers]

You should be able to do something like this

UPDATE yourtable
SET yourtable.Field1 = UCase([yourtable]![Field1]), yourtable.field2 = UCase([yourtable]![field2])
...
...

Hope this helps

Andy

 

[Dydom]

Thank you for your answer, that's work well !