>Why is it that when I do this:
>
>UPDATE ACRONYM SET ACRONYM="" WHERE PKID=10575
>
>SQL Server 6.5 will always put a default space for a length of 1 in the table?
>
>How can we accomplish a length of 0 which is what I am trying to do here?

Can you UPDATE with NULL?