LTRIM() not removing spaces
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:
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?