Thank you for your reply. However, I tried with queryout and still did not work. Have I used the correct syntax or BCP with SP.....except queryout....