Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty syntax to update a character field
Message
From
05/03/1998 18:23:59
Edward Crawford
City Facilities Management
Glasgow, United Kingdom
 
 
To
05/03/1998 17:56:27
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Re: Empty syntax to update a character field
Miscellaneous
Thread ID:
00082836
Message ID:
00082845
Views:
34
>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform