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