Just to add to what others have said, NULL and EMPTY are not at all the same things. NULL is an unknown state unlike EMPTY which is a known state.

>how do you test if a string is not = to ""? i tried null that did nothing for me the pgm just blows past this statement everytime in my code