>>IF LEN(@tcSaleNo) = 0
>>  -- Only spaces
>>...
>>
>>-- If string includes numbers only
>>IF CAST(@tcSaleNo AS int) = 0
>>  -- Only spaces or 0's
>>...
>