I've got a rather arduous data import/conversion task to complete with a huuuuge table in SQL Server 2005.

There is a column called content, of which many values are preceded by one or more spaces. I tried running the following query to remove these values:

Code sql:
UPDATE documents SET content = LTRIM(content);

It comes back with 9500 rows affected but the query has not affected a single row: there are still spaces at the start of many of them.

I hope this describes the problem adequately. Is someone able to help me out here?

Cheers