changing blanks to ''

[William Kossack]

I have an Access table with one primary key and am attempting to update
a non-key field, using

UPDATE tblMethtest SET fev1timemeth = '' WHERE SID = '0041R';

When I do this, the field subsequently contains 5 blanks instead of the
zero-length string I tried to put into it. This problem occurs
regardless of whether I execute the SQL from within Cold Fusion or from
within Access as an Access query. The same problem occurs on any
non-key text field in the table, ie, the field gets filled with blanks
to its defined length.

The field is defined as follows, according to Access's Documenter:

fev1timemeth Text 5
AllowZeroLength: True
Attributes: Fixed Size
Collating Order: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
Data Updatable: False
DisplayControl: Text Box
GUID: Long binary data
Ordinal Position: 52
Required: False
Source Field: fev1timemeth

[R.A.Balder]

You will have to replace it with the NULL() value. Blank is in fact and
ASCII value, and I think what you are looking for is to empty the field.
Then NULL() should be the value to use.

Brgds
Rolfern

"William Kossack" <ko******@njc.org> wrote in message
news:40***************@njc.org...h

I have an Access table with one primary key and am attempting to update
a non-key field, using

UPDATE tblMethtest SET fev1timemeth = '' WHERE SID = '0041R';

When I do this, the field subsequently contains 5 blanks instead of the
zero-length string I tried to put into it. This problem occurs
regardless of whether I execute the SQL from within Cold Fusion or from
within Access as an Access query. The same problem occurs on any
non-key text field in the table, ie, the field gets filled with blanks
to its defined length.

The field is defined as follows, according to Access's Documenter:

fev1timemeth Text 5
AllowZeroLength: True
Attributes: Fixed Size
Collating Order: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
Data Updatable: False
DisplayControl: Text Box
GUID: Long binary data
Ordinal Position: 52
Required: False
Source Field: fev1timemeth

[Trevor Best]

William Kossack wrote:

I have an Access table with one primary key and am attempting to update
a non-key field, using

UPDATE tblMethtest SET fev1timemeth = '' WHERE SID = '0041R';

When I do this, the field subsequently contains 5 blanks instead of the
zero-length string I tried to put into it. This problem occurs
regardless of whether I execute the SQL from within Cold Fusion or from
within Access as an Access query. The same problem occurs on any
non-key text field in the table, ie, the field gets filled with blanks
to its defined length.

The field is defined as follows, according to Access's Documenter:

fev1timemeth Text 5
AllowZeroLength: True
Attributes: Fixed Size

You're having a giraffe aren't you?