Empty syntax to update a character field

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:00:13

Bryan Jackson
Oklahoma City, Oklahoma, United States

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:

00082837

Views:

>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)... ?

Map

View

Click here to load this message in the networking platform