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