Hi Guys,
i am using query to update nulls to "Null" string on temp table:
IT is not working because last 4 columns are numbers.
1. It is possible to specify what kind if field we have(like number) to change Null to ...?
2. ...To what? How you are handling updating nulls in number fields columns?
I have 0 also there so i can not use 0 i think and afraid it will not work with joins...
Please help,
Jacek
i am using query to update nulls to "Null" string on temp table:
Code:
UPDATE tblVolumeOSMountOptionsTemp
SET OSType = Nz(OSType,"Null"),
OSDistro = Nz(OSDistro,"Null"),
OSVersion = Nz(OSVersion,"Null"),
StorageProtocol = Nz(StorageProtocol,"Null"),
ProtocolVersion = Nz(ProtocolVersion,"Null"),
ProviderFileSystemType = Nz(ProviderFileSystemType,"Null"),
MountPath = Nz(MountPath,"Null"),
OSVolumeName = Nz(OSVolumeName,"Null"),
ConsumerFileSystemType = Nz(ConsumerFileSystemType,"Null"),
ConsumerFulfillment = Nz(ConsumerFulfillment,"Null"),
ProviderFulfillment = Nz(ProviderFulfillment,"Null"),
ProviderMountOptions = Nz(ProviderMountOptions,"Null"),
ConsumerMountOptions = Nz(ConsumerMountOptions,"Null"),
ProviderLinuxMountFreq = Nz(ProviderLinuxMountFreq,"Null"),
ConsumerLinuxMountFreq = Nz(ConsumerLinuxMountFreq,"Null"),
ProviderLinuxMountPassno = Nz(ProviderLinuxMountPassno,"Null"),
ConsumerLinuxMountPassno = Nz(ConsumerLinuxMountPassno,"Null")
IT is not working because last 4 columns are numbers.
1. It is possible to specify what kind if field we have(like number) to change Null to ...?
2. ...To what? How you are handling updating nulls in number fields columns?
I have 0 also there so i can not use 0 i think and afraid it will not work with joins...
Please help,
Jacek