DSXchange

Hi guys,

I have a column 'DOC1' which is 10 bytes CHAR.
I have to populate 'A' if this column is blank.
I am using the logic If (IsNull(DOC1) Or DOC1=" ") Then DOC1 = A Else DOC1.

Somehow, this logic is not catching the blanks on the DOC1, Is there a way to check for the SPACES on this field?

Thanks

If Len(Trim(DOC1)) < 1 Then 'A' Else DOC1

Thanks for the help, it worked.

This can not work in a parallel job, where a CHAR must contain the correct number of characters.