Glad you caught that one with the empty function.

I was suggested to use the empty fundtion for the same syntax examples on some older code.

I actually would have preferred: IF EMPTY(ALLTRIM(test)) myself. removes only one check, but maintains accuracy (if test is a char of course), and could be spaces as Gregory brought up.

maybe we should take the examples so far and see if we can build a good size list to help others and/or discuss...