>>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?
>
>could you use ...SET ACRONYM = CHR(0)... ?

I tried it and SQL Server 6.5 returns that it can't understand that function.