I get a bunch of unwated spaces in the Char, varchar, and nchar fields. I have then set to 500 becasue it is like a memo field. When i go to update it it wont let me becasue of all the extra spaces. please help!!!
use the Trim functio to get rid of unwanted spaces http://msdn.microsoft.com/scripting/vbScript/doc/vsfctLTrim.htm<BR>