Results 1 to 8 of 8
Thread: LTRIM() not removing spaces
Oct 14, 2009, 08:00 #1
- Join Date
- Mar 2002
- Bristol, UK
- 0 Post(s)
- 0 Thread(s)
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?