Remoing blank characters in a string of text

[grayt26]

Hi all,


I have a table and dotted within multiple rows of that tables are strings of text that seem to have blanks at the end of them, so....


'abc ' instead of 'abc'


This is causing me to have duplicates when i export out of sql.


Is there an easy way of sweeping the whole table and removing these?

Thanks

 

[bborissov]

UPDATE MyTable SET MyStringField = LTRIM(RTRIM(MyStringField))

Make all fields (of course only these you need) to be varchar instead of CHAR(xx) before that.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[grayt26]

ok thanks that has helped on some of the fields.

thanks

 

[bborissov]

And what doesn't works on others?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP