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
How to check if a column is blank
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: