How do I convert one ASCII character in an SQL-database?


We found that during migration of data from an AS/400 to MS SQL-server, ASCII code 255 was used for the character ‘Blank’. Normally blank is code 32. Does anybody know an easy way to convert the character in all tables in the database?

TIA for replies,