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
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