>>>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?
>
>That works.
>
>However, the LEN() of ACRONYM is now NULL as the value is.
>
>How would I extract that record using a SQL? I tried:
>
>SELECT * FROM ACRONYM WHERE ISNULL(ACRONYM)
>
>but this gives an error.
>
>What I am trying to do is to know which records have an empty value for ACRONYM.
The syntax for checking for NULL values in Transact-SQL is:
"SELECT * FROM ACRONYM WHERE ACRONYM IS NULL"
HTH
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
