While trying to create dynamic SQL and append the text collums from syscomments, which are varchar(255). I have been experiencing "phantom" spaces which make the output from my select statement useless. More over, I'm not sure if this related, but now several of the trig's in the database don't appear to be working and none of the databases's stored procedures exist. I'm wondering if DBCC check table could help me with this. The ASE version is the OS is NT with service pack 6. If you could help I'd appreciate it.