When the SET Destination is a Logic Field


The destination field is set to blank, 1 (yes), or 0 (no), based on the value of the source field.

Source logic

The source field is copied directly to the destination field.

Source alpha

If the value of the first position of the source field is 0, N, or n, the destination field is set to a value of 0 (no). If the value of the first position of the source field is blank, the destination field is set to a value of blank. Otherwise, the destination field is set to a value of 1 (yes).

Source number

If the source field is null, the destination field is set to blank. Otherwise the destination field is set to 0 (no) if the source field is equal to 0, or 1 (yes) if the source field is not equal to 0.

Source date

If the source field is null, the destination field is set to blank. If the source field is a Gregorian binary date and has a value of 0, the destination field is set to 0 (no). Otherwise, the destination field is set to a value of 1 (yes).