Yes! That works as desired. Thank You!

Are there other ways though, for evaluating it?

--something like:

IF isnull(@OrderNumRtrn, 0) = 0 OR @OrderNumRtrn = '000000'

PRINT 'Do Something'

ELSE

PRINT 'Do Nothing'

I did not know I couldn't SET @Variable before trying to SELECT into it, and have it be a factor. I guess I'm thinking that SELECTing into the variable would overwrite the initial string value. And, if there is nothing returned by the query,the SELECT would set @Variable to NULL.